| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook format lost after saving.
Hi, I am using Excel 2007. The file I am working on is fine until few hours
ago, I re-open the file, all the file format is gone! It looks like the format is reset. All the number are now in 5 dec places. I manually re-format the entire workbook, saved and re-opened it, the format is not there. I tried to save into another file name, but still the same problem. When I work with other files, there is no such problem. Appreciate your help on this. Thanks a million! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
I am having exactly the same problem. After setting up my spreadsheet the
way I want it, I save and exit. When I re-open the file, all formatting is gone! Nothing is centered, fonts are reset, nothing in bold, significant digits are reset, underlining is in an odd state, etc, etc. The only way around it for me was to save in 2007 format (.xlsx). With that file format, my spreadsheet formatting remains intact, but nobody I work with can open it. When I save as .xls so that they can open my files, the formatting is screwed up. Needless to say, my boss is not very happy because he has OfficeXP. Anyone know of a fix for this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
Hello,
Has anyone received a response on this one? This has happened to a few of my ..xls worksheets now and I am getting frusterated. A handful of Users are working with Excel 2007 and the rest are working in Excel 2003. The 2007 Users are working in compatibility mode and the file extenstions are .xls. But the formats are getting lost and when we reformat and/or rename the workbook it remains, almost like corrupted if you will. So thus having to create a new spreadsheet. We are talking massive amounts of data. Is there an issue with a worksheet being updated and saved between users. Please remember we have our compatibility checker on. Desperately need resolution. "2-Tents" wrote: I am having exactly the same problem. After setting up my spreadsheet the way I want it, I save and exit. When I re-open the file, all formatting is gone! Nothing is centered, fonts are reset, nothing in bold, significant digits are reset, underlining is in an odd state, etc, etc. The only way around it for me was to save in 2007 format (.xlsx). With that file format, my spreadsheet formatting remains intact, but nobody I work with can open it. When I save as .xls so that they can open my files, the formatting is screwed up. Needless to say, my boss is not very happy because he has OfficeXP. Anyone know of a fix for this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
Hi Iona,
Make sure Office 2007 SP1 is installed. -- Cheers macropod [MVP - Microsoft Word] "Iona" wrote in message ... Hello, Has anyone received a response on this one? This has happened to a few of my .xls worksheets now and I am getting frusterated. A handful of Users are working with Excel 2007 and the rest are working in Excel 2003. The 2007 Users are working in compatibility mode and the file extenstions are .xls. But the formats are getting lost and when we reformat and/or rename the workbook it remains, almost like corrupted if you will. So thus having to create a new spreadsheet. We are talking massive amounts of data. Is there an issue with a worksheet being updated and saved between users. Please remember we have our compatibility checker on. Desperately need resolution. "2-Tents" wrote: I am having exactly the same problem. After setting up my spreadsheet the way I want it, I save and exit. When I re-open the file, all formatting is gone! Nothing is centered, fonts are reset, nothing in bold, significant digits are reset, underlining is in an odd state, etc, etc. The only way around it for me was to save in 2007 format (.xlsx). With that file format, my spreadsheet formatting remains intact, but nobody I work with can open it. When I save as .xls so that they can open my files, the formatting is screwed up. Needless to say, my boss is not very happy because he has OfficeXP. Anyone know of a fix for this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
Thank you so much for your prompt response. However, the users have up to SP3
installed. Should we still be encountering issues? "macropod" wrote: Hi Iona, Make sure Office 2007 SP1 is installed. -- Cheers macropod [MVP - Microsoft Word] "Iona" wrote in message ... Hello, Has anyone received a response on this one? This has happened to a few of my .xls worksheets now and I am getting frusterated. A handful of Users are working with Excel 2007 and the rest are working in Excel 2003. The 2007 Users are working in compatibility mode and the file extenstions are .xls. But the formats are getting lost and when we reformat and/or rename the workbook it remains, almost like corrupted if you will. So thus having to create a new spreadsheet. We are talking massive amounts of data. Is there an issue with a worksheet being updated and saved between users. Please remember we have our compatibility checker on. Desperately need resolution. "2-Tents" wrote: I am having exactly the same problem. After setting up my spreadsheet the way I want it, I save and exit. When I re-open the file, all formatting is gone! Nothing is centered, fonts are reset, nothing in bold, significant digits are reset, underlining is in an odd state, etc, etc. The only way around it for me was to save in 2007 format (.xlsx). With that file format, my spreadsheet formatting remains intact, but nobody I work with can open it. When I save as .xls so that they can open my files, the formatting is screwed up. Needless to say, my boss is not very happy because he has OfficeXP. Anyone know of a fix for this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
There are different service packs for different versions. SP3 relates
to XL 2003, but so far there has been only one SP for XL 2007 - have you got this for your machines which run XL 2007? Pete On Jan 14, 12:11*am, Iona wrote: Thank you so much for your prompt response. However, the users have up to SP3 installed. Should we still be encountering issues? "macropod" wrote: Hi Iona, Make sure Office 2007 SP1 is installed. -- Cheers macropod [MVP - Microsoft Word] |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
Hi, I am also getting the same problem and I have SP1 installed on Office
2007. Can I try anything else? "Pete_UK" wrote: There are different service packs for different versions. SP3 relates to XL 2003, but so far there has been only one SP for XL 2007 - have you got this for your machines which run XL 2007? Pete On Jan 14, 12:11 am, Iona wrote: Thank you so much for your prompt response. However, the users have up to SP3 installed. Should we still be encountering issues? "macropod" wrote: Hi Iona, Make sure Office 2007 SP1 is installed. -- Cheers macropod [MVP - Microsoft Word] |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
Same problem here. I have opened a case with Microsoft.
The problem obviously is not widespread, but Im seeing an increasing number of posts regarding this issue. I'm convinced it is related to compatibility handling of Excel 2003 workbooks in the Office 2007 environment. Oddly, it seems limited to only some 2003 workbooks. Is there some feature or corruption that is tolerated by Office 2003, but not by Office 2007? Im considering bulk conversion of 2003 workbooks to 2007 workbooks on a hunch the problem will be masked or removed. Hoping Microsoft will find the cause, but our desktop update project is now on hold. "Roo" wrote: Hi, I am also getting the same problem and I have SP1 installed on Office 2007. Can I try anything else? "Pete_UK" wrote: There are different service packs for different versions. SP3 relates to XL 2003, but so far there has been only one SP for XL 2007 - have you got this for your machines which run XL 2007? Pete On Jan 14, 12:11 am, Iona wrote: Thank you so much for your prompt response. However, the users have up to SP3 installed. Should we still be encountering issues? "macropod" wrote: Hi Iona, Make sure Office 2007 SP1 is installed. -- Cheers macropod [MVP - Microsoft Word] |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
I can also confirm the same problem.
Can't wait for a solution now! "rootman" wrote: Same problem here. I have opened a case with Microsoft. The problem obviously is not widespread, but Im seeing an increasing number of posts regarding this issue. I'm convinced it is related to compatibility handling of Excel 2003 workbooks in the Office 2007 environment. Oddly, it seems limited to only some 2003 workbooks. Is there some feature or corruption that is tolerated by Office 2003, but not by Office 2007? Im considering bulk conversion of 2003 workbooks to 2007 workbooks on a hunch the problem will be masked or removed. Hoping Microsoft will find the cause, but our desktop update project is now on hold. "Roo" wrote: Hi, I am also getting the same problem and I have SP1 installed on Office 2007. Can I try anything else? "Pete_UK" wrote: There are different service packs for different versions. SP3 relates to XL 2003, but so far there has been only one SP for XL 2007 - have you got this for your machines which run XL 2007? Pete On Jan 14, 12:11 am, Iona wrote: Thank you so much for your prompt response. However, the users have up to SP3 installed. Should we still be encountering issues? "macropod" wrote: Hi Iona, Make sure Office 2007 SP1 is installed. -- Cheers macropod [MVP - Microsoft Word] |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
I have the same problem...
No answer in sight... Frank "Shan" wrote: I can also confirm the same problem. Can't wait for a solution now! "rootman" wrote: Same problem here. I have opened a case with Microsoft. The problem obviously is not widespread, but Im seeing an increasing number of posts regarding this issue. I'm convinced it is related to compatibility handling of Excel 2003 workbooks in the Office 2007 environment. Oddly, it seems limited to only some 2003 workbooks. Is there some feature or corruption that is tolerated by Office 2003, but not by Office 2007? Im considering bulk conversion of 2003 workbooks to 2007 workbooks on a hunch the problem will be masked or removed. Hoping Microsoft will find the cause, but our desktop update project is now on hold. "Roo" wrote: Hi, I am also getting the same problem and I have SP1 installed on Office 2007. Can I try anything else? "Pete_UK" wrote: There are different service packs for different versions. SP3 relates to XL 2003, but so far there has been only one SP for XL 2007 - have you got this for your machines which run XL 2007? Pete On Jan 14, 12:11 am, Iona wrote: Thank you so much for your prompt response. However, the users have up to SP3 installed. Should we still be encountering issues? "macropod" wrote: Hi Iona, Make sure Office 2007 SP1 is installed. -- Cheers macropod [MVP - Microsoft Word] |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
I have exactly the same problem in my company. Office SP1 installed and it's
still not working. I'd kill for a solution ;) "Frank the Tank" wrote: I have the same problem... No answer in sight... Frank "Shan" wrote: I can also confirm the same problem. Can't wait for a solution now! "rootman" wrote: Same problem here. I have opened a case with Microsoft. The problem obviously is not widespread, but Im seeing an increasing number of posts regarding this issue. I'm convinced it is related to compatibility handling of Excel 2003 workbooks in the Office 2007 environment. Oddly, it seems limited to only some 2003 workbooks. Is there some feature or corruption that is tolerated by Office 2003, but not by Office 2007? Im considering bulk conversion of 2003 workbooks to 2007 workbooks on a hunch the problem will be masked or removed. Hoping Microsoft will find the cause, but our desktop update project is now on hold. "Roo" wrote: Hi, I am also getting the same problem and I have SP1 installed on Office 2007. Can I try anything else? "Pete_UK" wrote: There are different service packs for different versions. SP3 relates to XL 2003, but so far there has been only one SP for XL 2007 - have you got this for your machines which run XL 2007? Pete On Jan 14, 12:11 am, Iona wrote: Thank you so much for your prompt response. However, the users have up to SP3 installed. Should we still be encountering issues? "macropod" wrote: Hi Iona, Make sure Office 2007 SP1 is installed. -- Cheers macropod [MVP - Microsoft Word] |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook format lost after saving.
Hi rootman. Did you ever get an answer from MS on this?
Are there no MS staff or MVPS on here who can clear this up? "rootman" wrote: Same problem here. I have opened a case with Microsoft. The problem obviously is not widespread, but Im seeing an increasing number of posts regarding this issue. I'm convinced it is related to compatibility handling of Excel 2003 workbooks in the Office 2007 environment. Oddly, it seems limited to only some 2003 workbooks. Is there some feature or corruption that is tolerated by Office 2003, but not by Office 2007? Im considering bulk conversion of 2003 workbooks to 2007 workbooks on a hunch the problem will be masked or removed. Hoping Microsoft will find the cause, but our desktop update project is now on hold. "Roo" wrote: Hi, I am also getting the same problem and I have SP1 installed on Office 2007. Can I try anything else? "Pete_UK" wrote: There are different service packs for different versions. SP3 relates to XL 2003, but so far there has been only one SP for XL 2007 - have you got this for your machines which run XL 2007? Pete On Jan 14, 12:11 am, Iona wrote: Thank you so much for your prompt response. However, the users have up to SP3 installed. Should we still be encountering issues? "macropod" wrote: Hi Iona, Make sure Office 2007 SP1 is installed. -- Cheers macropod [MVP - Microsoft Word] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color Changes When Saving 2007 Workbook as 97 - 2003 Workbook | Excel Discussion (Misc queries) | |||
| move/copy lost format in destination workbook | Excel Discussion (Misc queries) | |||
| How do I keep formulas for being lost when saving in 2007? | Excel Discussion (Misc queries) | |||
| lost work without saving it. can I get it back? | Excel Discussion (Misc queries) | |||
| Lost my original spreadsheet by saving over it with the same name | Excel Discussion (Misc queries) | |||
![YY san.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
