Excel Flies on Sharepoint linking to files which are in turn linking - Microsoft Community

i have 3 tiers of excel files on sharepoint - 1 front line team enter metrics, 1 front line managers summarize team numbers, 1 upper level manager summarize front line manager data.

the 8 front line manager files each link around 8 files front line employees enter data.  upper level manager file links these 8 front line manager files.

the front line manager file takes 20 seconds update of data, upper level manager file takes 2 minutes.  there way speed process upper level manager or there better way set up?

i guessing upper level manager having maybe go through , @ of underlying files rather 8 front line manager files, not sure if there way make process more efficient.  cells trying reference on front line manager files formulas based on data pulled front line team files.

moved from: office / excel / windows 8 / office 2013

hi dwighty2607,

 

your guess right. when upper level manager checks file, file looks data in 8 files front line manager in turn again looks data in other 8 files front line team.  since data linked through formulas , dynamic, , other workbooks gets updated every , then, upper level manager’s file gets updated every time data changed in other two-tier files, of course take time process.

 

if want upper level manager file update faster, have suggestion, can create new sheet (tab) in front line manager’s workbook , ask them copy-paste summary in sheet not formula value. can link sheet upper level manager’s workbook. way upper level manager’s workbook data 1 tier less processing.  

 

this, however, have drawback, if anytime of front level manager forgets paste summary, upper level manager not updated data. so, @ time front level managers must remember paste data in new sheet.

 

 

thanks,

neha

Office / SharePoint Online / Windows 8 / Office 365 for business