Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to make changes to multiple excel work books at one time
Hi guys,
I have about 200 cost sheets all set up to pull from a source page which then pulls from a master list I would like to know if there is a way to update the links in all the pages at once? To be more specific my company is changing from lotus 1-2-3 to the new excel 2007 and I am in charge of updating all of it. I have in my folder now about 200 cost sheets that need to be updated to new excel code and the link to the source file changed, now the code will be similar on all files, although each column has it's own vlook function so I don't know if that would be able to be automated but I figured to link to the source book could be changed in all of them at once any help would be greatly appriciated. P.S. I am talking about a MASS amount of data the master file has first sheet with about 4000 lines times 8 columns all code, with 6 sheets behind it with about 400 lines of all code. Then of course the 500 cost sheets (FUN FOR ME!!!) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Work Books | Excel Discussion (Misc queries) | |||
excel scroll bars within work books | Excel Worksheet Functions | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Shared use of excel work books | Excel Discussion (Misc queries) | |||
Histogram made from multiple exel work books. | Charts and Charting in Excel |