Linked Spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1553423%22%20slang%3D%22en-US%22%3ELinked%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1553423%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20number%20of%20linked%20spreadsheets.%20In%20the%20past%20the%20destination%20spreadsheet%20could%20be%20opened%20first%20and%20then%20the%20source%20sheets%20without%20a%20problem.%20Now%20if%20the%20destination%20spreadsheet%20is%20opened%20first%2C%20when%20the%20source%20sheets%20are%20opened%20all%20of%20the%20formulae%20are%20corrupted%20losing%20the%20Tab%20name%20from%20the%20refernce%20and%20displaying%20'%23Ref'%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1553423%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1553611%22%20slang%3D%22en-US%22%3ERe%3A%20Linked%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1553611%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F743661%22%20target%3D%22_blank%22%3E%40David_Adams%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eopening%20order%20should%20not%20make%20any%20difference.%20If%20you%20open%20the%20destination%20first%2C%20it%20can%20not%20necessarily%3C%2FP%3E%3CP%3Eupdate%20information%20from%20source%20before%20it%20is%20opened%20too.%20But%20causing%20reference%20error%20sounds%20odd.%3C%2FP%3E%3CP%3EHave%20you%20copied%20source%20worksheets%20to%20another%20location%20while%20destination%20worksheet%20has%20been%20closed%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20can%20lead%20to%20reference%20error%2C%20because%20old%20file%20location%20of%20source%20workbooks%20doe%20not%20match%20any%20more.%20Another%20possibility%20is%20that%20you%20have%20renamed%20source%20workbooks%20worksheets%20while%20destination%3C%2FP%3E%3CP%3Eworkbook%20has%20been%20closed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eattached%20two%20excel-workbooks%20(%20source%20and%20destination%20with%20formulas%20)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564702%22%20slang%3D%22en-US%22%3ERe%3A%20Linked%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564702%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15762%22%20target%3D%22_blank%22%3E%40Olli%20Haavisto%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20response%20-%20your%20files%20worked%20once%20I%20had%20saved%20them%20on%20my%20laptop.%20I%20am%20working%20on%20a%20VPN%20link%20and%20believe%20it%20is%20to%20do%20with%20the%20Automatic%20checking%20of%20files%20downloaded%20over%20the%20internet%20-%20when%20I%20disabled%20this%20my%20links%20remain%20in%20place%20despite%20which%20order%20I%20open%20he%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EDavid%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a number of linked spreadsheets. In the past the destination spreadsheet could be opened first and then the source sheets without a problem. Now if the destination spreadsheet is opened first, when the source sheets are opened all of the formulae are corrupted losing the Tab name from the refernce and displaying '#Ref'

2 Replies
Highlighted

@David_Adams 

 

Hi,

 

opening order should not make any difference. If you open the destination first, it can not necessarily

update information from source before it is opened too. But causing reference error sounds odd.

Have you copied source worksheets to another location while destination worksheet has been closed ?

 

That can lead to reference error, because old file location of source workbooks doe not match any more. Another possibility is that you have renamed source workbooks worksheets while destination

workbook has been closed.

 

attached two excel-workbooks ( source and destination with formulas )

 

Highlighted

Hi@Olli Haavisto 

 

Thanks for your response - your files worked once I had saved them on my laptop. I am working on a VPN link and believe it is to do with the Automatic checking of files downloaded over the internet - when I disabled this my links remain in place despite which order I open he files.

 

Thanks

David