About Us

stickboy

My problem is that I want to change the source workbook but the Change source button is not available? The source file updates weekly (one for Monday, tuesday, etc). Before these files are updated, they are archived to a different folder but all under the same name (i.e. MON TUE WED etc.). I want my formulas to compute using the archived files but the Change Source button is not available! I had to change the formula references in each of the 30 workbooks containing 9 wokrsheet each!!! HEEELLPPP!!!

oh... and even the UPDATe NOW button is also grayed over.... i've tried playing around with the setting in the Calculations tab of the Options menu but I can't seem to get it... should the settings be changed to manual?... which buttons should be checked/unchecked?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Update Chart Source (w/macro?)	tx12345	Excel Worksheet Functions	0	January 4th 06 02:18 AM
how do i get my mail merge to update the data source at each merge	Steel_Monkey	Excel Discussion (Misc queries)	0	November 30th 05 08:41 AM
change data source for many queries at once?	Sam Raymond	Excel Worksheet Functions	0	July 11th 05 04:59 PM
How to change (Excel) source of all linked objects in a word docu.	Wheelwater	Excel Discussion (Misc queries)	1	April 23rd 05 12:17 PM
Applying a currency rate that doesn't change when source updated	Redsmartie	Excel Worksheet Functions	3	April 1st 05 06:54 PM

Menu

About Us