Avatar of Patricia Timm
Patricia Timm
Flag for United States of America asked on

processing time between column and table

I have a column with 100,00 records. Sometimes when placing a filter and sorting it runs long and times out. Does creating a table for that column help in process time? Another words it wont take as long to filter etc in table format as opposed to a plain column filter? Maybe the processing speed between a table and regular column doesnt matter? Thanks
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Patricia Timm

8/22/2022 - Mon

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Kesavan Jeganarayanan

Try this by selecting cell A1 and and press CTRL + End. It moves to last cell of the table.

Delete all the rows / columns after where your actual data ends. Save the file, close it, and reopen it. 

If this is not working, copy your data to new workbook will help you. 


I have a column with 100,00 records
When you filter and sort, are other columns affected or is your worksheet data only one column wide?

Please post a representative sample of the data in the column.
What kind of filter criteria are you using?
Are you sorting after filtering?
Are the sorting and filtering operations independent of one another?
Patricia Timm

I have 64bit and 8gb of ram.
The file includes 17,357 records I try to do conditional formatting - checking for duplicates and color coding them red for the client id then I get a spinning wheel .... that keeps going and usually times out.
1. Any ideas on why this is happening
2. How do I stop it from running... I tried escape but still keeps going... do I have to restart my computer? Thanks in advance
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy

Conditional Formatting using formulas is volatile. I suggest that you remove it from your large table, and use a macro that you run periodically to check for duplicates.
Patricia Timm

Why is conditional formatting so popular? Ease of use? Would you recommend creating tables and using power query? would that help? Also how do I get out of a running query? Escape wont work... Any recommendations aside from shutting down?
Patricia Timm

Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.