A colleague of mine has an Excel file where the font sizes and background cell colours of individual cells sometimes appear to have changed spontaneously when she re-opens the document.
She had formatted the columns to different colours to indicate what they were being used for (various types of response in an interview). There are no formulae in the document whatsoever, just text. There is no conditional formatting anywhere in the workbook. She is using Office 2007, as is her colleague who also uses the document, but the file is in .xls format. Both users have identical RGB values on their palettes (i.e. the default Office 2007 settings).
When the font size changes, the cell ostensibly remains set to the original font size 11 but all text within the cell has been changed to font size 6. When the cell colour changes, it is to a subtly different shade of the original colour, e.g. the mid-red on their palette to a dark red that is not on their palette.
Obviously, reverting these changes is simple (and we don't need help on that), but it is time-consuming for them to have to check each cell for changes and make any reversions; also, they are worried about the possibility of spontaneous changes after they deliver the document to their client.
Any thoughts on how to prevent this from recurring would be appreciated!
She had formatted the columns to different colours to indicate what they were being used for (various types of response in an interview). There are no formulae in the document whatsoever, just text. There is no conditional formatting anywhere in the workbook. She is using Office 2007, as is her colleague who also uses the document, but the file is in .xls format. Both users have identical RGB values on their palettes (i.e. the default Office 2007 settings).
When the font size changes, the cell ostensibly remains set to the original font size 11 but all text within the cell has been changed to font size 6. When the cell colour changes, it is to a subtly different shade of the original colour, e.g. the mid-red on their palette to a dark red that is not on their palette.
Obviously, reverting these changes is simple (and we don't need help on that), but it is time-consuming for them to have to check each cell for changes and make any reversions; also, they are worried about the possibility of spontaneous changes after they deliver the document to their client.
Any thoughts on how to prevent this from recurring would be appreciated!
