Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked workbooks, changing links
I have a report that is really several workbooks linked together. We produce
the report monthly so this month, they all end in 2007_10, next month 2007_11. In Excel 2000, I would simply open all the workbooks and do a File, Save As and the links automatically changed to the new version. In Excel 2003, the formlas stay the same (so they're all linked to last months data). I've tried the Edit..Links...Change Source, and Find/Replace, but in each case I get a message "Formula too long". Any other suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as changing links in other workbooks | Excel Discussion (Misc queries) | |||
Absolute value changing in linked workbooks | Links and Linking in Excel | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
linked workbooks | Excel Discussion (Misc queries) | |||
3 workbooks linked | Excel Discussion (Misc queries) |