Once the row has calculated, I want it to accept values and not recalculate until certain conditions met

steveanders86

New Member
Joined
Jan 31, 2015
Messages
3
Hello all,
I have a spreadsheet for our processing plant that brings in real-time data from our plant through PI datalink. Every day we have to open the spreadsheet, enter in manual data, calculate and report the values. Once the month is over, we compile all the data, clear entries, and start over with a new month.
The problem is the spreadsheet is giant and takes a very long time to calculate each time I need to update anything. I'm not a computer expert but it seems reasonable to me that there is a way to tell excel that once the day has passed, accept the values and don't calculate anymore.
I already have IF-statements in my cells to make sure that it only calculates rows up to the current day but if I could also tell it to stop once the day has past, it would greatly increase the calculation speed and our productivity.

Does anyone have any suggestions?


Thanks,
Steve
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,005
you can turn off auto calculate altogether and use F5 whenever you want to calculate
 

AlexandraT

Board Regular
Joined
Mar 23, 2015
Messages
144
Or try copy and paste as values for previous entries? If you ever forget to turn auto calculate on again the numbers won't update and you could be using wrong data.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,194
Messages
5,835,914
Members
430,394
Latest member
Ace_Quared

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top