Have an existing spreadsheet with hundreds of Xlookups.
Sheet works but it refreshes too slow via Excel online & mobile device browsers.
Deliverable: Review attached spreadsheet, identify performance issues & make adjustments to formulas, formatting, etc in order to refresh page much faster (current sheet is set to refresh manually, which takes longer than 3-4 minutes to complete)
The best you can do is to go through formulas one by one and if you find any arguments or variables repeated, use the LET function to calculate it only once.
I tried to copy any formula to show you but the sheet is protected.
Thank,
Mohamed GadAllah
The first thing to do is get rid of all those entire column references in the Xlookups & limit the formula to a sensible range. Along with using LET the formula in C9 would look likeFormula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks