ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IF statement based on need to recalculate (https://www.excelbanter.com/excel-worksheet-functions/248558-if-statement-based-need-recalculate.html)

pdberger

IF statement based on need to recalculate
 
Good morning --

I have a very large workbook that takes a long time to calculate. I've set
it to manual recalculation, but would like a cell to remind the user that
they need to do so. Is there a formula that does that, or do I need to write
it as VBA?

Users have Excel 03 & 07.

Thanks in advance.

Squeaky

IF statement based on need to recalculate
 
Maybe you can just write "REMEMBER TO RECALCULATE AFTER MAKING CHANGES" in
big letters.

"pdberger" wrote:

Good morning --

I have a very large workbook that takes a long time to calculate. I've set
it to manual recalculation, but would like a cell to remind the user that
they need to do so. Is there a formula that does that, or do I need to write
it as VBA?

Users have Excel 03 & 07.

Thanks in advance.



All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com