I have a workbook that we have used for about 8 years. A couple of months ago, it quit keeping colors and formatting. You can put the colors on and change the formatting, but when you reopen the file, it has no colors and the formatting is gone. Can you tell me how I can get the colors and formatting back and keep them. The worksheet pages are protected when saved.
thanks
Glenna