M
matt.ehrman
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
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