Excel

Copper Contributor

I have an issue on when I save a file, data in the sheet changing itself, like: I have used a function "Now()" to insert date and it's working perfectly, at the same time I have change the settings to manual from Automatic in the Calculation Options  which is under the Formulas tab.

Has anyone got any idea to solve this issue?

 

Note: The file I have saved in the format of Excel Macro Enabled worksheet. ( because I'm using macro to insert date and time and also some other data from other cells by copying and pasting them onto another cells.)

0 Replies