Hi Folks,
I am having a problem with Excel 2007 files losing all formatting
(merged cells, colors, borders, and data formatting (99% turns into
0.99)) when I open a file on our office server make edits and then
save the new file on the server. Each sheet usually has a mix of
locked and unlocked cells and I unprotect the sheet to make edits.
Also, something is fundamentally changed with the file as its size
doubles or triples. If I reopen the corrupted file and redo any of
the formatting and try to save it none of the new formatting is
retained either. Has anyone else ever experienced a problem like
this? It also only occurs when I edit a file on the server. If I
make the same kind of modifications on a local file, there is no
problem. We have had some tech support people in here to deal with
this problem three times and I am not convinced they fixed it for good
today.
If anybody has any insight on this problem, thank you in advance!
Cheers,
Matt
fyz - 29 Mar 2008 13:50 GMT
Hi,
I think you can try a popular Excel file recovery tool called Advance
Excel Repair to repair your Excel file. It is a powerful tool to repai
corrupt or damaged Excel files.
Detailed information about Advanced Excel Repair can be found a
http://www.datanumen.com/aer/
And you can also download a free demo version a
http://www.datanumen.com/aer/aer.exe
Hope this helps.
Ala
--
fy