| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving a file that you do not want to update the links to other fi
I have a summary report file that is linked to other files that I update the
info each week. I give the summary file a new name each week(basically the week ending date).When I save the summary report and open it up after the second week instead of keeping the original info it keeps updating with the most current info. How can I make the summary report file stop updating and just keep the info that it was saved with originaly for that week only. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Saving a file that you do not want to update the links to other fi
EditLinks
Break the links which converts the formulas to values then save. Gord Dibben MS Excel MVP On Wed, 9 Jul 2008 17:04:01 -0700, Derric wrote: I have a summary report file that is linked to other files that I update the info each week. I give the summary file a new name each week(basically the week ending date).When I save the summary report and open it up after the second week instead of keeping the original info it keeps updating with the most current info. How can I make the summary report file stop updating and just keep the info that it was saved with originaly for that week only. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| after saving excel 2003 file, functions do not update anymore | Excel Discussion (Misc queries) | |||
| How do I update links from a file that hasn't yet been updated? | Excel Worksheet Functions | |||
| automatically update links without opening file | Excel Worksheet Functions | |||
| update a closed file via links | Excel Discussion (Misc queries) | |||
| Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) | |||
Linear Mode
