I have an Excel file that was used in conjunction with other Add-Ins (e.g., Oracle Financial Analyzer). When I go to menu Insert, Name, Define I see almost 500 of these names which are not relevant to my report. The references point to old directories and I am wondering what the impact on performance would be when these persist.
Wouldn't claim to know the answer definitively - I think in part it will depend upon how they are both defined & utilised:
http://www.decisionmodels.com/calcsecretsb.htm
http://www.decisionmodels.com/optspeedf.htm
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks