My Environment
Platform : PC desktop
Host: Excel
Office version number: Microsoft® Excel® for Microsoft 365 MSO (Version 2309 Build 16.0.16827.20166) 64-bit
Operating System: Windows 10 pro
Dear Team,
I'd like to express my gratitude for the prompt support, which has been invaluable for our business.
Currently, I'm working with a workbook containing over 115 worksheets, and I have several queries:
I need to assign unique IDs to specific sets of cells within a worksheet. It's essential that if I insert a row or column, the assigned ID should seamlessly move with the corresponding cell. For example, if cell B1 has an ID of "001," and I insert a column before column 1, the ID "001" should now be associated with cell B2.
The workbook takes considerable time to load with 115+ tabs in Excel desktop. Are there alternative methods to improve loading time?
I've noticed that using named ranges for certain cells becomes sluggish when the named range extends beyond 30,000 cells. Is there a way to optimize this and enhance Excel performance?
Your assistance in resolving these concerns is crucial for the efficiency of our operations.
Thank you for your continued support.