File formatting get changed even after reformatting and saving

[neeraj2050]

Greetings!!
I am having an excel file which I am unable to share. If I reuse that file next time(i.e with updated figures) my formatting gets totally changed(colors get off, numerical digit is shown with decimal which is more than 4 digits after decimal.

Even after reformatting, saving and closing the file if the same file is opened again the same problem pop up again.
Request your support into this matter
Regards
Neeraj Kumar Agarwal

 

[xlstime]

Please share few info.

What is excel version
What is save file extn.
Any error?
In this on pivot table?
are you using name range?
share your excel setting like External content, protected view and advanced setting
try with stop auto update

Greetings!!
I am having an excel file which I am unable to share. If I reuse that file next time(i.e with updated figures) my formatting gets totally changed(colors get off, numerical digit is shown with decimal which is more than 4 digits after decimal.

Even after reformatting, saving and closing the file if the same file is opened again the same problem pop up again.
Request your support into this matter
Regards
Neeraj Kumar Agarwal

 

[Hui]

Is anybody else using it in between your uses?
Do they have a different version of Excel?

Are thereConditional Formats in the file?

 

[neeraj2050]

I amonly using that file.
Compatibility mode is shown. But if I save it in different version, it repairs the file and shows (Repaired)
Yes Conditional formatting is used.

 

[Hui]

The newer versions of Excel supports colors and formats that are not backward compatible with *.xls file formats
This would explain the behaviour you mentioned

So save the file in a new format *.xlsm or *.xlsb
then re-open

 

[neeraj2050]

Not working. Actually into file on pressing Alt+F8 macro tab pops up and it contains some macro. But while selecting the Edit/Step into mode it says Reference is not valid

 

[Hui]

Can you post the file here so we can review ?