Custom View Very Slow

D

ddate

I have created custom views to take a 52 column report and show only 15-20
columns at a time. It takes up to 2 minutes to switch views. This seems
rather slow and not very usable in a live meeting. Any suggestions on
speeding this up?

I tried grouping but since some of the same columns are used in multiple
views I could not get grouping to work the same.
 
N

Nick Hodge

Is it possible that there are many formulas in this data? If so getting rid
of them may speed it up

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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

Word 2016 opening sooo slow 0
Entourage 2004 very slow changing views 5
Word 2010...veerrryyyyy slow 3
Custom View > show is very slow 0
this code is VERY slow, is it the code or perhaps a worksheet issue 32
FP2003/Vista - VERY slow on large webs ??? 0
design view changes very slow 1
Office 365 for Business vs Office Home - 'Save to' & Other Questions 0

Top