hi everyone,

Is there any microsoft article which provide information regarding this issue.

thank you in advance

regards

arun av

• Edited by arun av 1 hour 35 minutes ago

Hi arun av,

According to your description, you opened the previous excel file in new version of Excel. Did you get the dialogue box as shown in the figure when close the file?

Ideally, the issue is caused when the first time you open a file that was last saved in a previous version of Excel, the file is completely recalculated. For more information about Excel fully recalculating workbooks when they are opened for the first time, you can refer to following links:

https://support.microsoft.com/en-us/kb/210162

https://support.office.com/en-sg/article/Change-formula-recalculation-iteration-or-precision-73fc7dac-91cf-4d36-86e8-67124f6bcce4#bmlearn_about_calculating_workbooks_tha

Hope its helpful.

Regards,