Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Changes cell formating after file is saved
I have found in Excel 2007 in some cases when I save and then reopen a file,
the formating of a cell has changed. It always changes from General (no formatting) to a Date format. I find i happens most often when the files get large (1meg), and have many tabs (8+). It did not happen before in Excel 2003. I am stumped |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Changes cell formating after file is saved
Has anyone found a solution or cause? I have searched the internet but have
not encountered any more info than what is contained in the previous post. "Jeff Page" wrote: I have found in Excel 2007 in some cases when I save and then reopen a file, the formating of a cell has changed. It always changes from General (no formatting) to a Date format. I find i happens most often when the files get large (1meg), and have many tabs (8+). It did not happen before in Excel 2003. I am stumped |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Changes cell formating after file is saved
No luck here...I responded to a similar post regarding this issue (see post
"Default Cell Format Changed?" in Excel General Questions). To play it safe I reverted back to Office 2003 where I never encountered any issues. As described by Jeff Page, I think the file size and multiple worksheets is somehow affecting the default cell format. If you decide to change the cell format back to "General", Excel 2007 will simply revert the formated cells back to "Date" again. So don't waste your time! Not finding a simple, quick, and permanent fix is frustrating. ~JMD "Dan" wrote: Has anyone found a solution or cause? I have searched the internet but have not encountered any more info than what is contained in the previous post. "Jeff Page" wrote: I have found in Excel 2007 in some cases when I save and then reopen a file, the formating of a cell has changed. It always changes from General (no formatting) to a Date format. I find i happens most often when the files get large (1meg), and have many tabs (8+). It did not happen before in Excel 2003. I am stumped |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Changes cell formating after file is saved
Check out
http://www.microsoft.com/office/comm...2fsettings.xml I still don't know how this setting got changed, but I suspect that one of my users is making this change without realizing the extent of it's effect. -rakudave "JMD" wrote: No luck here...I responded to a similar post regarding this issue (see post "Default Cell Format Changed?" in Excel General Questions). To play it safe I reverted back to Office 2003 where I never encountered any issues. As described by Jeff Page, I think the file size and multiple worksheets is somehow affecting the default cell format. If you decide to change the cell format back to "General", Excel 2007 will simply revert the formated cells back to "Date" again. So don't waste your time! Not finding a simple, quick, and permanent fix is frustrating. ~JMD "Dan" wrote: Has anyone found a solution or cause? I have searched the internet but have not encountered any more info than what is contained in the previous post. "Jeff Page" wrote: I have found in Excel 2007 in some cases when I save and then reopen a file, the formating of a cell has changed. It always changes from General (no formatting) to a Date format. I find i happens most often when the files get large (1meg), and have many tabs (8+). It did not happen before in Excel 2003. I am stumped |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Excel conditional formating, reference cell containing specif | Excel Discussion (Misc queries) | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
Why is path name added to active cell when Excel file is saved? | Excel Discussion (Misc queries) | |||
Need to link excel "cell" to a pre saved PDF file?? How do I do th | Excel Worksheet Functions | |||
store file saved date in cell | Excel Worksheet Functions |