Slow reaction on cell changes

**Mike1001** · 08-26-2009, 04:57 AM

There were just four additional defined names to identify folder and file name for the add-in file to be copied into the standard add-in folder plus alternate folder and file name in case a user had mapped her/his drive differently.
The total number of defined cell names is 72 (there is an additional approx. 50 macro buttons with defined names). I have applications with many many more defined names that work way faster.

**romperstomper** · 08-26-2009, 05:14 AM

It's not so much the number of names as how they are defined. How/where are those additional 4 names used? And what exactly do you mean by 'buttons with defined names'?

**Mike1001** · 08-26-2009, 05:36 AM

I had just added those defined cell names in a hidden sheet that I use for calculations by just using the Insert, Name, Define functionality or directly entering them into the Name Box. Those cells are only referred to by macro code (no cell formulas). Names are like fdMacroFile or fnMacroWkBk.
The macro buttons with defined names are buttons with macro assignments that I call like btnA7 instead of Button 1 or the like in order to have a stable reference in case of required automatic updates to the file.

**romperstomper** · 08-26-2009, 07:15 AM

Oh I see, you just mean you changed the button names.
I can't think of another reason offhand for the behaviour you describe if it's not to do with volatile functions or event code. (if it were just a question of formula complexity I would have expected the behaviour to be there before, although if you have moved lots of UDFs to the add-in, that might slow things down a little.)

**Mike1001** · 08-26-2009, 10:53 AM

After all of your suggestions, I guess I found the reason for the slow file:
It seems to be linked pictures!
I stripped my file down by eliminating all remaining macros - performance was still bad.
I deleted a number of linked pictures - and there we go: performance is back to normal!

One of the sources for linked pictures was a relatively heavy graph on that particular file, which explains why one doesn't see that poor performance in other files which use less heavy graphs!

Thank you all, especially RomperStomper, for your advise!
I learnt a lot about optimizing my applications from that, which will certainly help me in future applications!

Mike

**shg** · 08-26-2009, 12:27 PM

I had completely forgotten about that as a potential cause. A few years ago, I had a single linked picture in a workbook to see what was going on in a few cells on another sheet, and it completely whacked performance.

Going to write that down, right now ...