New
#1
Excel Warnings - Links to Other Workbooks
I have an Excel Workbook that I use for tracking expenditures and month-end bank balances, so I update it frequently. I create a new workbook for that purpose with each new year. I've tried doing this a number of different ways but I keep ending up with the same erroneous message when I open the workbook. At least I believe the message is false, but I cannot figure out how to get rid of it.
The message I get is this:The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?If I click Yes, it shows me the Documents folder with the previous year's workbook highlighted in the File Name box. If I choose "Ok" or "Cancel," the message goes away.
- To update all linked information, click Yes.
- To keep the existing information, click No.
If I click No, the message goes away.
There is no difference to the content of the workbook regardless of what I choose because, as far as I know, the workbook isn't really linked to last year's workbook.
I have wondered if this problem has something to do with how I create each year's workbook. Here are the different ways I've tried to do it:
- I've tried Save As..., and given the workbook a new name for the new year. After that, I've deleted all of the old data except the December expenditures, the sheet that lists the monthly bank balances, and the chart that is derived from the list of monthly bank balances.
- I've copied and pasted the old workbook in the Documents folder, given the copy a new name, and proceeded to delete all but the three sheets listed in #1.
- I've created a new workbook and copied those three sheets from the old workbook to the new workbook.
- I've copied just the December worksheet to a new workbook.
No matter what I do, I still get the message that says the workbook is linked to another workbook (last year's workbook).
The reason I keep those three pages is to maintain the formatting for the monthly expenditures worksheet and to keep the running list of the monthly bank balances, going back to 2010, and the chart that shows how the balances have been trending.
Is there any way to break the so-called link?
Thanks in advance!