a real stumper - slow excel caused by names or query ?

[tranx]

I have an issue with an excel worksheet I've created.

WorkbookA has "Names" which are used to define drop-down menus in
WorksheetA (so my users don't accidentally mistype a response). These
"Names" are defined to reference cells in WorksheetB (also in
WorkbookA) which itself is populated by a database query, pulling from
another Excel WorkbookB.

The logic is that WorkbookB should not be touched by the User, only an
Admin, and Workbook A is used by User. The Names in WorkbookA are to
prevent incorrect entries.

Now that I've set it up, WorkbookA is moving really sluggish, but if I
delete all the Names it speeds up again. Of course, I need the Names,
so how can I workaround this ??

Thanks for any help/comments !

Using Excel 2003 SP1

-dean

 

[Dave Peterson]

If you open workbookB, does workbookA speed up?

Maybe you can open it readonly mode???

 

[tranx]

No, if I open workbookB it does not speed up workbookA.

The issue persists in read-only mode also

 

[Dave Peterson]

I was hoping that the delay would disappear if workbookA didn't have to retrieve
info from a closed book.

But I don't have another suggestion.