I have a quite extensive Excel workbook that I am using to track data and
changes. I had made changes to a coupld of the pages on an older version of
the document and wanted to keep those changes so I copied the sheets that I
needed to the more current version of the document. As a result I have
inadvertantly created links to the older version and it is messing me up. I
have tried useing the "Break Links" under Edit and that doesn't seem to do
anything. I am not wanting to have to redo everything but it looks like I am
left with that being the only option. Does anyone have any suggestions.
What is happening is that some of the named ranges are having the names of
sheets inserted into their formulas when they don't belong there, when I try
and remove them and save it doesn't stay edited.