Excel Links

%3CLINGO-SUB%20id%3D%22lingo-sub-1076369%22%20slang%3D%22en-US%22%3EExcel%20Links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1076369%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20lot%20of%20spreadsheets%20that%20link%20crosswise%20and%20every%20month%20all%20files%20must%20be%20changed%20to%20the%20new%20month.%3CBR%20%2F%3EFor%20example%2C%20a%20file%20has%20100%20cells%20where%20each%20cell%20links%20into%205%20different%20sheets%20e.g.%20A201910%2C%20B201910%2C%20C201910%2C%20D201910%2C%20E201910%20-%20they%20should%20then%20be%20updated%20to%20A201911%2C%20B201911%2C%20C201911%2C%20D201911%2C%20E201911.%20I%20go%20in%20and%20change%20links%20for%20A201910%20to%20A201911%20(or%20I%20had%20a%20macro%20that%20did).%20It%20took%20approx.%203%20min%20total%20to%20update%20all%205%20links%20in%20one%20spreadsheet%20but%20after%20upgrading%20to%20Office%20365%20it%20now%20takes%2030%20min%20...%20I%20have%20tried%20to%20have%20both%20A201910%2C%20B201910%2C%20C201910%2C%20D201910%2C%20E201910%20and%20A201911%2C%20B201911%2C%20C201911%20%2C%20D201911%2C%20E201911%20open%20at%20the%20same%20time%2C%20but%20just%20a%20little%20helps.%3C%2FP%3E%3CP%3EI%20work%20on%20a%20server%20in%20house%20and%20not%20locally%20on%20my%20computer.%3C%2FP%3E%3CP%3EAre%20there%20any%20who%20know%20of%20a%20fix%20to%20this%20or%20have%20experienced%20the%20same%20thing%3F%3C%2FP%3E%3CP%3EWe%20are%20running%20Office%20365%20ProPlus%3C%2FP%3E%3CP%3ESincerely%3CBR%20%2F%3ESimon%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

I have a lot of spreadsheets that link crosswise and every month all files must be changed to the new month.
For example, a file has 100 cells where each cell links into 5 different sheets e.g. A201910, B201910, C201910, D201910, E201910 - they should then be updated to A201911, B201911, C201911, D201911, E201911. I go in and change links for A201910 to A201911 (or I had a macro that did). It took approx. 3 min total to update all 5 links in one spreadsheet but after upgrading to Office 365 it now takes 30 min ... I have tried to have both A201910, B201910, C201910, D201910, E201910 and A201911, B201911, C201911 , D201911, E201911 open at the same time, but just a little helps.

I work on a server in house and not locally on my computer.

Are there any who know of a fix to this or have experienced the same thing?

We are running Office 365 ProPlus

Sincerely
Simon

0 Replies