lost formatting

Hello all. I recently opened a workbook, made many changes, saved with a new name, and when I reopened it, the formatting was gone...colors, lines backgrounds etc, though all the formulas are intact. This is a really large workbook with many tabs, and would take forever to reformat. Is there...

I have a spreadsheet I have been using and updating successfully for years. Yesterday, i opened it and all formatting is lost. When i add formatting to the sheet and save it, the formatting is gone. Numbers and text values are saved, but no formatting can be saved. The version I am having...

This is a well-known problem though I couldn't find a solution here or anywhere. When a protected sheet has cells which are not locked, but have formatting and data validation, a simple copy/paste into those cells from another sheet loses the formatting and validation in the target cells...

I have a user that is using Excel 2007 SP2 with all current updates. There is an Excel files (xlsx format) that he appends data to that seems to lose all formatting about once a week. He opens the file and Excel states that it has to repair and then removes all formatting. The user appends...