Hi,
My company has recently upgraded from excel 2007 to 2013.
We are using named ranges in order to store values in a database.
One of our pricing tools have alot of named ranges, approx 75000.
When running this tool in excel 2007, it works without any problems at all.
When i run it on excel 2013 the application is (Not responding) which then causes it to crash.
I've tried to find the threshold where the amount of named ranges affects the performance.
Already at approx 2-3k named ranges i get a small, but clearly notable, delay.
We are currently running on ver. 15.0.4797.1003
Any help is appreciated!
/Tomas
My company has recently upgraded from excel 2007 to 2013.
We are using named ranges in order to store values in a database.
One of our pricing tools have alot of named ranges, approx 75000.
When running this tool in excel 2007, it works without any problems at all.
When i run it on excel 2013 the application is (Not responding) which then causes it to crash.
I've tried to find the threshold where the amount of named ranges affects the performance.
Already at approx 2-3k named ranges i get a small, but clearly notable, delay.
We are currently running on ver. 15.0.4797.1003
Any help is appreciated!
/Tomas
