I am sharing a file with a ton of other users. I must have data linked to this file, but I have no idea where it is. Now that the data is there, I don't really need it to be linked and I don't want everyone to continue to get the message as they open the file asking if they want to update to the links. Is there a way to simply turn off that message? I went to edit links to try to change the source location, but it won't let me....and I tried to link it to itself and that won't work either.
What happens when you click on Edit / Links... ?
There is an option to set the Startup Prompt there to be.... "don't display alert and don't update automatic links" which should take care of the issue.
Hope this helps
Is this Startup Promt under Edit/Links? I only have the option to Update Now, Change Source, Open Source, and the Update "Automatic" dot is selected, under my Links.
I'm using Excel 2002 (XP) and the option is under Edit / Links. Must be a feature in the newer version. I also have an option to "Break Links" which converts the link formula in the cell to its current value.
If you have neither of those options, the Edit / Links window should at least give you a list of links in your workbook and if it's not too many, you can manually put the correct value in the cell in place of the link to get rid of them.
If you can't find the links, post a copy of your file here so we can take a look at it.
Unfortunately I do not have XP, but thank you anyways. I will try to find someone who does.
Don’t have an account yet? Register yourself now and be a part of our community!