Our tech team has launched updates to The Nest today. As a result of these updates, members of the Nest Community will need to change their password in order to continue participating in the community. In addition, The Nest community member's avatars will be replaced with generic default avatars. If you wish to revert to your original avatar, you will need to re-upload it via The Nest.
If you have questions about this, please email help@theknot.com.
Thank you.
Note: This only affects The Nest's community members and will not affect members on The Bump or The Knot.
Excel users - need help!
I used to work in Excel all the time for my job, but it was on 2007 and I'm currently working in 2003 so I'm having trouble figuring out how to fix this.
I have a spreadsheet (let's call it Banana), that contains links back to another spreadsheet with data (let's call it Apple). These are separate documents, not worksheets in the same document. I know all the links in Banana are right because I've re-linked it twice and tested it with fake data in Apple three times.
However, every time I go to open Banana, I get a pop up that says one or more links cannot be updated. And you have the option to continue or edit links. The problem is Banana works properly and pulls over the data if Apple is also open. However, if Apple is closed, I get this stupid pop up about links and such and none of the data is updated.
I'm sure it's probably some security setting but i can't figure out where it is.... anyone have any advice for me?
Re: Excel users - need help!
I could be wrong but doesn't Excel want both workbooks to be open in order to do the updates? I'm not sure if you can have Apple be closed but still have Bannana pick up updates from it while it's closed. I could be wrong though.
If you need to send it to other people and you don't want that pop-up to appear, I think you go to Edit > Break Links which will remove the links to Apple but keep the data. Of course, it will not longer reference Apple but it will keep that pop up from appearing when you send it to other people.
check out this page and see if that helps
http://office.microsoft.com/en-us/excel-help/control-when-links-are-updated-HP005199380.aspx
thanks, i found that info using help feature, but it still doesn't work. if i just open the destination doc i don't even get an "update" or "don't update" option, just the "continue" or "edit links" pop up i got before.
it seems to refuse to update data without having the source docs also open. So frustrating!
perhaps i just need to bite the bullet and get a newer version. sigh.
i figured it out! it's only taken me a full day.
they were being saved as excel 2007 docs (.xlsx or .xlsm) vs. plain old .xls, so it was converting the doc every time i opened it and there is the problem.
aren't those "helpful" default features fun? glad you figured it out!