Spreadsheet constantly recalculating

[Rosstamon]

Hi,
I have a spreadsheet that is currently 7800 rows and goes to column BK. A few months back I noticed that everytime I change anything, for instance use a filter at the top of one of the columns, there is a 20 to 30 second delay which also sort of locks up my spreadsheet and at the very bottom of the spreadsheet in the Status Bar it says "CALCULATING (8 PROCESSOR(S): xx%" where xx moves somewhat slowly from 0 to 100%.

This spreadsheet has a few nested ifs and, pulls from tables, and Conditional Formatting. I know you will need more info but not sure what, so I'll wait for questions and then answer.

My objective is to speed up the constant CALCULATING, but I'm not sure what the answer is. I've tried replaicing table lookups with just the data, and getting rid of some of the formulas with nested if's and getting rid of ALL of the Conditional Formatting but nothing seems to fix it. Is it possible that at 7800 rows and growing, it will just be this way from now on?

I appreciate any help or suggestions. I know absolutely nothing about VBA or programming so that's not a possibility for me right now. If it turns out that this is the only answer I may just have to learn to live with this or find a different solution.

Thanks,
RR

 

[JoeMo]

Are the "tables" one- and/or two-input data tables? These can slow down calculation considerably. In any case, why not set calculation to manual and calculate only when you desire?

 

[Myconservator]

https://support.office.com/en-us/ar...recision-73a772d5-6224-407c-8029-60a47488b6aa

Specifically
[h=2]Change when a worksheet or workbook recalculates[/h]

 

[SpillerBD]

You may also have links to other workbooks.
Despite having Calculations set to manual, I had some linked data (inadvertently) that was resulting in Calculations to occur.

 

[johnnyb5]

I solved this in one of my sheets by coping the entire sheet and pasting values so all my formulas became common cell values. Then no more recalculating.