Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Input form data in a remote spreadsheet

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Input form data in a remote spreadsheet
Hey guys, So I have a problem with an Excell assignment. We have a spreadsheet with active deals and details for each of them on a shared partition on the server. I have to create a separate file, like a form (with data validation restrictions), which people can open, fill out the data,...

Excel Help Forum - Excel General: if contains forumela

Feed2Mail notification - new post on Excel Help Forum - Excel General
if contains forumela
I have cells which contact RQIA SP RIDDOR HSC TRUST SP / RQIA RIDDOR / RQIA RIDDOR / SP HSC TRUST / RQIA

Excel Help Forum - Excel Formulas & Functions: Averages and sequences

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Averages and sequences
Hi All, Hoping someone out there can help. I have the follow table of monthly Revenues for close to a 3 year period. I am trying to analyse monthly revenue increases. ie Sept 2012 minus Sept 2011 (this is the easy part) Number of issues: (a) if the series starts with a zero sequence...

Excel Help Forum - Excel Programming / VBA / Macros: Macro to Transpose data in rows to columns

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Macro to Transpose data in rows to columns
Hi, is it possible to develop a macro which transpose rows into column, i have attached a sample excel, QC Sheet has the raw data which i will get from QC and i wanted to convert into Tableau Sheet format. the Macro should be flexible to handle increase/decrease in columns/rows. Any help...

Excel Help Forum - Excel General: Excel Tasks in Month switcher

Feed2Mail notification - new post on Excel Help Forum - Excel General
Excel Tasks in Month switcher
Hello, I'm currently creating a master plan doc for my projects and I created a calender within it, though now I'm having the problem that when I want to switch to the next month or the previous one, I don't know how I can keep my data in those fields. For example. I put something in the 25th...

Office IT Pro General Discussions Forum: No File lock even if user has file open

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
No File lock even if user has file open

We have few Vista and Win 7 desktops on our environment. Server is Win Srv 2008 r2 Std with Active Directory, Remote Desktop and File Services roles installed.

When user "A" opens a excel file for editing from server share, it comes locked and read/write lock can be seen on servers Shared Files -> Open files console. After few minutes the locking disappears and user "B" is enable to open the file for editing even when user "A" has still same file opened for editing. This causes problems with saving modifications when users cant save to the opened file.

Need help to resolve what is causing this locking issue and how to fix it.

Thank you!

Excel Help Forum - Excel General: Excel loading time, load fails and general excel speed

Feed2Mail notification - new post on Excel Help Forum - Excel General
Excel loading time, load fails and general excel speed
Hey guys, I have had a bit of issues with one of my excel files since it has grown to huge sizes! over 100,000 rows of data, which extends across to column BIQ! Most of these columns are not raw data but manipulations of the original data which extends across to column CZ. Many of the...
Subscribe to: Posts (Atom)