| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a file and not allowing it to update cells
I have a weekly summary report that is linked to several other spreadsheets
that I update weekly. I save the summary report each week with a new file name (basically the week ending date). But when I open the file a couple of weeks later the information for that specific week ending is purged and the most current info is now in its place. How can I save a file and not allow it to update cells that are linked to other files. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving a file and not allowing it to update cells
hi
removed the links. regards FSt1 "Derric" wrote: I have a weekly summary report that is linked to several other spreadsheets that I update weekly. I save the summary report each week with a new file name (basically the week ending date). But when I open the file a couple of weeks later the information for that specific week ending is purged and the most current info is now in its place. How can I save a file and not allow it to update cells that are linked to other files. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving a file and not allowing it to update cells
Hello FSt1:
How do I remove the links? "FSt1" wrote: hi removed the links. regards FSt1 "Derric" wrote: I have a weekly summary report that is linked to several other spreadsheets that I update weekly. I save the summary report each week with a new file name (basically the week ending date). But when I open the file a couple of weeks later the information for that specific week ending is purged and the most current info is now in its place. How can I save a file and not allow it to update cells that are linked to other files. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving a file and not allowing it to update cells
copy the cells with links;
paste special, "values" "Derric" wrote: Hello FSt1: How do I remove the links? "FSt1" wrote: hi removed the links. regards FSt1 "Derric" wrote: I have a weekly summary report that is linked to several other spreadsheets that I update weekly. I save the summary report each week with a new file name (basically the week ending date). But when I open the file a couple of weeks later the information for that specific week ending is purged and the most current info is now in its place. How can I save a file and not allow it to update cells that are linked to other files. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving a file and not allowing it to update cells
EditLinksBreak Links
Gord Dibben MS Excel MVP On Fri, 11 Jul 2008 07:31:01 -0700, Derric wrote: Hello FSt1: How do I remove the links? "FSt1" wrote: hi removed the links. regards FSt1 "Derric" wrote: I have a weekly summary report that is linked to several other spreadsheets that I update weekly. I save the summary report each week with a new file name (basically the week ending date). But when I open the file a couple of weeks later the information for that specific week ending is purged and the most current info is now in its place. How can I save a file and not allow it to update cells that are linked to other files. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving file without empty cells | Excel Discussion (Misc queries) | |||
| Saving a file that you do not want to update the links to other fi | New Users to Excel | |||
| after saving excel 2003 file, functions do not update anymore | Excel Discussion (Misc queries) | |||
| check certain cells for data before saving file | Excel Worksheet Functions | |||
| Cells widen after saving and reopening file | Excel Discussion (Misc queries) | |||
Hybrid Mode
