Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to copy 3 spreadsheets and get the formulas to work
I have 3 workbooks, payments payroll and receipts which are linked by formulas.
I want to use them as master copies and use them each year. However when I try to copy and rename them the formulas always refer back to the originals and not to the renamed files. Can you help please? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to copy 3 spreadsheets and get the formulas to work
With Excel closed, first make a backup of the three workbooks.
Then open all three workbooks. At this point each workbook can "see" the other two as an open workbooks. Then SaveAs each workbook with its new name. Then verify that the formulas in all three workbooks refer to the "new name" versions. Finally close the workbooks. -- Gary''s Student - gsnu201001 "Peter Cross" wrote: I have 3 workbooks, payments payroll and receipts which are linked by formulas. I want to use them as master copies and use them each year. However when I try to copy and rename them the formulas always refer back to the originals and not to the renamed files. Can you help please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy column, paste special formulas & number formats doesn't work | Excel Discussion (Misc queries) | |||
Vlookup won't work on these two particular spreadsheets | Excel Worksheet Functions | |||
Formulas don't work after copy/paste from Lotus 1-2-3 97 (Excel 20 | Excel Discussion (Misc queries) | |||
Copying spreadsheets-did not work | Excel Discussion (Misc queries) | |||
Linking between spreadsheets does not work unless I have both spr. | Excel Discussion (Misc queries) |