Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel Warnings - Links to Other Workbooks

09 Nov 2015   #1
WebPixie

Windows 7 Pro 64bit
 
 
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?
  • To update all linked information, click Yes.
  • To keep the existing information, click No.
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.

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:
  1. 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.
  2. 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.
  3. I've created a new workbook and copied those three sheets from the old workbook to the new workbook.
  4. 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!


My System SpecsSystem Spec
.
09 Nov 2015   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Have you thought about using a Template for this. What you do is copy one of your yearly Spreadsheets & save it as a Template, giving it a name such as Yearly Expenditure Template or whatever. Just make sure you save a copy of the spreadsheet & save it as the Template & that you don't save your original as the Template as you will lose any info if you then change that one.

When you get to a new year you open that Template & delete all the info in it & start from fresh again. It will also have any formatting that you established in the original one. Then you can save this one with a new name & the Template will still be there for use the next year.

Set up a new Folder in your Documents directory & call if Excel Templates, so you can add others later if you wish.
My System SpecsSystem Spec
11 Nov 2015   #3
WebPixie

Windows 7 Pro 64bit
 
 

Quote   Quote: Originally Posted by Ranger4 View Post
Have you thought about using a Template for this. What you do is copy one of your yearly Spreadsheets & save it as a Template, giving it a name such as Yearly Expenditure Template or whatever. Just make sure you save a copy of the spreadsheet & save it as the Template & that you don't save your original as the Template as you will lose any info if you then change that one.

When you get to a new year you open that Template & delete all the info in it & start from fresh again. It will also have any formatting that you established in the original one. Then you can save this one with a new name & the Template will still be there for use the next year.

Set up a new Folder in your Documents directory & call if Excel Templates, so you can add others later if you wish.
Thank you for the suggestion. That sounds like a good idea!

Having a template should work well for the monthly expenditure pages but I'm trying to decide how best to maintain the list of the monthly account balances and the associated chart. It's convenient to have those in the same workbook that I use to track expenditures during the month, but it would be no good to have it as part of a template.

I will see what happens if I copy just those two pages from the current workbook to a new one. If that works, I could just do that when creating a new book for each new year.

Alternatively, I suppose, I could just keep those two pages (list & chart) as a separate workbook. Either way will reveal whether it's the monthly expenditure spreadsheets or the list of monthly account balances that is somehow linked to the previous year's workbook.

Thanks!
My System SpecsSystem Spec
.

11 Nov 2015   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

The best way to work out problems is to try various things & see if they will work the way you want them. So you may be able to use a Template for tracking monthly expenditures as well.

I use templates for keeping monthly weather data that my weather station software reports. I do a daily manual update of each days weather info into Access & then at the end of the month I copy that months data into an Excel spreadsheet Template, that maintains the formatting that I want & then I just make necessary changes to get daily averages etc..
Then I copy the various maximums, minimums & averages into another Template that keeps track of that data for the year to date. At the end of the year I have a very detailed record. At the start of the next year I repeat the procedure, just changing the year details as necessary.

So do some experimenting & see how you go, of course always use copies so don't wreck your data.
My System SpecsSystem Spec
Reply

 Excel Warnings - Links to Other Workbooks




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Excel Warnings - Macros
I have an Excel Workbook that I use a lot. As far as I know, the workbook doesn't contain any macros but I continue to get this message: C:\Users\AccountName\Documents\Spreadsheet.xls contains macros. Macros may contain viruses. It is always safe to disable macros, but if the macros are...
Microsoft Office
links is missing when pasting text with links in any browser or office
Hi, When I'm copying text withe links from the web and trying to paste it, The links is missing. I try to paste it into word or excel, and in all kinds of html editors in all browsers but the links are still missing. only text is shown. Is anybody here knows how to fix it? Tx very much...
Browsers & Mail
My problem with unsaved workbooks in Excel
Hello to all, I have few problems or misunderstandings about the auto-saving/recovering workbooks in Excel 2010 that try to explain them clearly as follows: First I create a New Microsoft Excel file And put some data into it and wait for more than 1 minute, because I changed the time of Save...
Microsoft Office
How do I stop Publisher Security Warnings On Desktop links
Whenever I click on a link on my Desktop the following message pops up. http://img684.imageshack.us/img684/8511/captureygw.jpg Uploaded with ImageShack.us This is in Windows 7 Home Premium. This means that the Group Policy Manager is not available. Please don't suggest that. I...
Installation & Setup
Muktiple workbooks inExcel 2010 save as XML file
Hi all It seems not possible to save a 2010 EXCEL spreadsheet containing multiple workbooks as an XML file -- however you CAN save it as a type 2003 XMLworkbook. This works and seems to conform to the XML standard but are MS going to drop this. XML is a decent OPEN common standard -- we use...
Microsoft Office
Activating Links in Excel 2007?
Hi does anyone know how to make "dormant" links active on a spreadsheet? So if I have www links how to I make them clickable? I should add that I am referring to making several hundred links clickable! Not just one or two which I have worked out - Thanks!!
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 05:55.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App