Can you stop formulas updating on a date?

Microsoft Excel home and student 2010 so...
September 20, 2010 at 02:35:13
Specs: Windows XP
I have a workbook that monitors year to date sales.

I have to submit a monthly report to our head office, I have created a seperate workbook for this purpose, and have created formulas linking to the original year to date workbook.

My question is, can I set the cells to stop updating? i.e. year to date sales links into my September page, can I set the September workbook to freeze the figure on 30th September rather than keep updating with my year to date workbook?

Thanks in advance for any suggestions!

See More: Can you stop formulas updating on a date?

Report •

September 20, 2010 at 14:02:07
You could add a macro in the ThisWorkbook module to keep checking the system date. Once the date reaches the date specified in the macro (or a date stored in a cell) it could replace the "link formulas" with the current values.

You could even add code that deletes itself once it replaces the formulas so that you wouldn't be sending workbooks with code in them to other users.

Report •
Related Solutions

Ask Question