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.

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.

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.

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.

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.