Slow lookups

[mtpaper]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I tried to read solutions to this but I didn't see anything constructive.

I have a lot of lookups.
Anytime I add any data, it's unbearably slow.
Everything is in one workbook.

I can turn off automatic calculation, but that's problematic as I have to remember to turn it back on when I switch to other workbooks.

Suggestions?
Thank you

 

[Niek Otten]

What is your data layout (horizontal? sorted? ascending?) and what is your formula?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Version: 2008
| Operating System: Mac OS X 10.5 (Leopard)
| Processor: Intel
|
| I tried to read solutions to this but I didn't see anything constructive.
|
| I have a lot of lookups.
| Anytime I add any data, it's unbearably slow.
| Everything is in one workbook.
|
| I can turn off automatic calculation, but that's problematic as I have to remember to turn it back on when I switch to other
workbooks.
|
| Suggestions?
| Thank you

 

[Julian Lewis-Booth]

Couldn't agree more, I have dozens of sheets with lookups (generally
vertical) that since the last update to version 12.1.12 take forever to
recalculate.

Most are sheets about 18-20 columns wide and 4-500 rows, doing a lookup on
on key vertically sorted table of about 4-16000 lines.

These used to take seconds to work with previously now we are talking
minutes, the biggest took 5 minutes to calculate last night before saving and
that is not what I would call huge.

I will have to reinstall office from my original Disk and not take the
latest update because I cant live with this level of performance and most of
my working sheets have some sort of lookup in them.

Julian

 

[Joe_LeBlanc]

Hi Julian,

Thanks for your post, sorry to hear about the performance problems you're experiencing. Is it possible for you to provide me with some example files so that I can investigate the issue? If not, an example of the kind of formula and data structure you're using would also be helpful.

Thank you!

-Joe LeBlanc
MacBU Excel team
(e-mail address removed)