Home

Data validation is extremely slow under Windows 10 (1903)

%3CLINGO-SUB%20id%3D%22lingo-sub-775017%22%20slang%3D%22en-US%22%3EData%20validation%20is%20extremely%20slow%20under%20Windows%2010%20(1903)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775017%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20started%20upgrading%20our%20CAD%20department%20from%20Windows%207%20to%20Windows%2010.%26nbsp%3B%20I%20have%20been%20going%20directly%20to%20feature%20release%201903.%26nbsp%3B%20After%202%20days%2C%20the%20first%20person%20I%20upgraded%20informed%20me%20that%20opening%20a%20specific%20spreadsheet%20in%20Excel%20was%20taking%20much%20longer%20than%20it%20had%20under%20Windows%207.%26nbsp%3B%20After%20investigating%20I%20have%20narrowed%20the%20problem%20down%20to%20Windows%2010%20(1903).%26nbsp%3B%20The%20problem%20does%20not%20occur%20when%20running%20under%20Windows%2010%20(1809).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20spreadsheet%20involved%20contains%20a%20good%20number%20of%20pull%20down%20lists%20that%20lookup%20people's%20names%20in%20a%20separate%20tab.%26nbsp%3B%20There%20is%26nbsp%3B%20a%20base%20spreadsheet%20that%20contains%20the%20framework%20including%20a%20number%20of%20tables.%26nbsp%3B%20The%20user%20then%20fills%20in%20the%20information%20including%20selecting%20names%20in%20up%20to%2030%20fields.%26nbsp%3B%20Some%20users%20may%20need%20to%20duplicate%20the%20original%20tab%20that%20contains%20the%20lookup%20fields.%26nbsp%3B%20The%20spreadsheet%20in%20question%20contains%20an%20additional%204%20tabs.%26nbsp%3B%20It%20takes%20up%20to%2030%20seconds%20to%20open%20this%20spreadsheet.%26nbsp%3B%20Under%20Windows%207%20it%20takes%20about%205%20seconds.%26nbsp%3B%20Delays%20are%20also%20noticeable%20when%20switching%20between%20tabs%20within%20the%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20overall%20size%20of%20each%20tab%20is%20140%20rows%20by%2059%20columns%2C%20not%20extremely%20large.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-775017%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Data%20Validation%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775108%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20is%20extremely%20slow%20under%20Windows%2010%20(1903)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775108%22%20slang%3D%22en-US%22%3ECheck%20whether%20the%20tabs%20contain%20objects%20(F5%2C%20Special%2C%20Objects%20or%20click%20the%20Magnifying%20glass%20and%20choose%20%22Selection%20pane%22.%3C%2FLINGO-BODY%3E
REAmention
Occasional Visitor

I have started upgrading our CAD department from Windows 7 to Windows 10.  I have been going directly to feature release 1903.  After 2 days, the first person I upgraded informed me that opening a specific spreadsheet in Excel was taking much longer than it had under Windows 7.  After investigating I have narrowed the problem down to Windows 10 (1903).  The problem does not occur when running under Windows 10 (1809).

 

The spreadsheet involved contains a good number of pull down lists that lookup people's names in a separate tab.  There is  a base spreadsheet that contains the framework including a number of tables.  The user then fills in the information including selecting names in up to 30 fields.  Some users may need to duplicate the original tab that contains the lookup fields.  The spreadsheet in question contains an additional 4 tabs.  It takes up to 30 seconds to open this spreadsheet.  Under Windows 7 it takes about 5 seconds.  Delays are also noticeable when switching between tabs within the spreadsheet.

 

The overall size of each tab is 140 rows by 59 columns, not extremely large.

 

Any suggestions would be appreciated.

1 Reply
Check whether the tabs contain objects (F5, Special, Objects or click the Magnifying glass and choose "Selection pane".
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies