database query/names issue, causing excel to be sluggish

T

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. These "Names" are defined to reference a 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 !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

a real stumper - slow excel caused by names or query ? 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Using TransferSpreadsheet to import from Excel to Access with variable file names 1
Sluggish performance 4
Exceltastic brings back the classic Excel menus 1
Creating parameters in excel for an access-linked query 0
The issue is specific to WORD 0
Excel sort column with indirectly referenced dymanic worksheet 1

Top