External References

%3CLINGO-SUB%20id%3D%22lingo-sub-3396215%22%20slang%3D%22en-US%22%3EExternal%20References%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3396215%22%20slang%3D%22en-US%22%3E%3CP%3EHoping%20to%20get%20some%20assistance%20here%20as%20I'm%20at%20a%20loss%20with%20the%20issue%20I'm%20experiencing%20with%20external%20references%20between%20two%20working%20Excel%20365%20files.%3C%2FP%3E%3CP%3E%3CEM%3E%3CSTRONG%3EBackground%20info%3A%3C%2FSTRONG%3E%26nbsp%3BI%20have%20a%20paid%20Office%20365%20subscription%20which%20I%20access%20through%20my%20Chromebook.%20I%20do%20not%20use%20the%20Android%20app%20for%20this%3B%20instead%2C%20I%20use%20the%20Chrome%20browser%20and%20access%20my%20Microsoft%20account%20that%20way.%20I%20am%20working%20with%20someone%20who%20has%20shared%20the%20folder%20where%20the%20two%20Excel%20files%20we%20are%20working%20in%20are%20housed%2C%20and%20he%20has%20made%20sure%20I%20am%20an%20%22owner%22%20of%20the%20workbooks.%20We%20have%20two%20spreadsheets%20(neither%20is%20super%20complex)%3A%20one%20for%202021%20and%20one%20for%202022.%20They%20each%20have%20three%20tabs%3A%20Transactions%2C%20Accounting%20calcs%2C%20P%26amp%3BL%20all%20jobs.%20Some%20of%20the%20data%20from%202021%20needs%20to%20be%20reflected%20in%202022%2C%20and%20we%20need%20it%20to%20auto%20update%20as%20transactions%20are%20entered%20into%202021%20(year%20is%20not%20closed%20yet%2C%20unfortunately).%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EProblem%20%231%3A%26nbsp%3B%3C%2FSTRONG%3EWhen%20I%20create%20the%20external%20reference%20and%20use%20the%20%22Paste%20Link%22%20function%2C%20I%20get%20a%20%23CONNECT!%20error%20in%20the%20cell%20and%20in%20the%20Workbook%20Links%20area%20it%20states%20%22Server%20Error.%22%3C%2FP%3E%3CP%3E%3CSTRONG%3EProblem%20%232%3A%26nbsp%3B%3C%2FSTRONG%3EWhen%20I%20use%20%22Paste%20Values%22%20it%20give%20me%20only%20that%20specific%20value%20from%20that%20specific%20copy%2Fpaste%20--%20and%20does%20not%20update%20as%20the%202021%20sheet%20is%20updated.%3C%2FP%3E%3CP%3E%3CSTRONG%3EProblem%20%233%3A%26nbsp%3B%3C%2FSTRONG%3EOne%20solution%20I%20have%20come%20across%20on%20message%20boards%20is%20to%20change%20the%20settings%20in%20the%20Trust%20Center%2C%20which%20is%20supposed%20to%20be%20under%20%22File%2C%20Options.%22%20The%20only%20option%20I%20have%20there%20is%20for%20%22Regional%20Format%20Settings.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20absolutely%20need%20this%20external%20reference%20to%20work%20so%20we%20can%20have%20accurate%20project%20budget%20details%20with%20every%20entry.%20I%20have%20searched%20more%20message%20boards%20than%20I%20can%20even%20count%20and%20even%20tried%20Microsoft%20support.%20I'm%20hoping%20someone%20in%20this%20community%20has%20had%20this%20issue%20before%20and%20found%20a%20solution%20they'd%20be%20willing%20to%20share%20with%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETina%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3396215%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hoping to get some assistance here as I'm at a loss with the issue I'm experiencing with external references between two working Excel 365 files.

Background info: I have a paid Office 365 subscription which I access through my Chromebook. I do not use the Android app for this; instead, I use the Chrome browser and access my Microsoft account that way. I am working with someone who has shared the folder where the two Excel files we are working in are housed, and he has made sure I am an "owner" of the workbooks. We have two spreadsheets (neither is super complex): one for 2021 and one for 2022. They each have three tabs: Transactions, Accounting calcs, P&L all jobs. Some of the data from 2021 needs to be reflected in 2022, and we need it to auto update as transactions are entered into 2021 (year is not closed yet, unfortunately).

Problem #1: When I create the external reference and use the "Paste Link" function, I get a #CONNECT! error in the cell and in the Workbook Links area it states "Server Error."

Problem #2: When I use "Paste Values" it give me only that specific value from that specific copy/paste -- and does not update as the 2021 sheet is updated.

Problem #3: One solution I have come across on message boards is to change the settings in the Trust Center, which is supposed to be under "File, Options." The only option I have there is for "Regional Format Settings."

 

I absolutely need this external reference to work so we can have accurate project budget details with every entry. I have searched more message boards than I can even count and even tried Microsoft support. I'm hoping someone in this community has had this issue before and found a solution they'd be willing to share with me.

 

Tina

0 Replies