Two file questions: SAVE and Link

%3CLINGO-SUB%20id%3D%22lingo-sub-3289565%22%20slang%3D%22en-US%22%3ETwo%20file%20questions%3A%20SAVE%20and%20Link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289565%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20odd%20things%20happening%20that%20I'm%20trying%20to%20figure%20out.%20They%20are%20really%20just%20annoyances%2C%20but%20I'm%20a%20perfectionist%20and%20would%20like%20to%20clear%20these%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20A%20file%20I'm%20opening%20shows%20%5BLinking%3A%20%22Prod0629.xls%22%5D%20in%20the%20bottom%20as%20Excel%20is%20trying%20to%20open.%20But%2C%20I%20can't%20figure%20out%20where%20Prod%200629%20is%20being%20referenced%20in%20the%20file.%20Is%20there%20a%20way%20to%20see%20that%20so%20I%20can%20remove%20it%3F%20Working%20from%20home%20(over%20VPN)%20takes%20forever%20to%20open%20the%20file%20since%20it's%20linked%20to%20an%20external%20file%20(plus%20all%20the%20other%20formulas%20and%20valid%20linkages%20that%20are%20in%20the%20file).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Another%20file%20I%20have%20is%20constantly%20asking%20me%20to%20Save%20when%20I%20close%20it%2C%20even%20though%20I%20haven't%20changed%20anything.%20It's%20the%20only%20file%20doing%20this%20that%20I%20use%20on%20a%20daily%20basis.%20It%20is%20a%20Macro%20Enabled%20Worksheet%20(just%20a%20reset)%20and%20I%20copy%2Fpaste%20special%20(123)%20some%20info%20in%20there.%20I%20just%20can't%20figure%20out%20why%2C%20after%203%20seconds%20of%20going%20to%20another%20file%20and%20coming%20back%20to%20it%20to%20close%2C%20it%20asks%20if%20I%20want%20to%20save.%20It%20does%20not%20have%20any%20linked%20fields%20to%20outside%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3289565%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I have two odd things happening that I'm trying to figure out. They are really just annoyances, but I'm a perfectionist and would like to clear these up.

 

1. A file I'm opening shows [Linking: "Prod0629.xls"] in the bottom as Excel is trying to open. But, I can't figure out where Prod 0629 is being referenced in the file. Is there a way to see that so I can remove it? Working from home (over VPN) takes forever to open the file since it's linked to an external file (plus all the other formulas and valid linkages that are in the file).

 

2. Another file I have is constantly asking me to Save when I close it, even though I haven't changed anything. It's the only file doing this that I use on a daily basis. It is a Macro Enabled Worksheet (just a reset) and I copy/paste special (123) some info in there. I just can't figure out why, after 3 seconds of going to another file and coming back to it to close, it asks if I want to save. It does not have any linked fields to outside data.

 

Thanks for the help.

0 Replies