Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
I've currently got a problem with the Excel 2007. i'll try to describe the problems as i found them. Customer service has 2 seperate instances of Excel open, they copy from one xlsx spreadsheet to another xlsx spreadsheet (seperate instances) the first time they copy somehting it works fine the second time they copy somehting it will coppy the cell structure, but the content will be empty from this i thought it might have been a clipboard error, but the clipboard works perfectly well in most cases. I asked around the office if this happened to anyone else, and it hasen't so i tried looking at why... We've recently updated from office 2003 to office 2007 and customer service is one of the few sections that have updated their spreadhseets to Excel 2007, this isn't unique but they are the only ones that are copying from a converted excel document into another converted excel document. After the user playign around for a bit he found out that it took maybe 20 copy / pastes between the 2 instances of Excel before one of them would corrupt. When it corrupts it comes up with this message Excel found unreadable content in 'MyExcelDocument.xlsx', Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes. Clicking no will stop everything, clicking Yes will bring up a further error message box with Repais to ''MyExcelDocument.xlsx' Excel was able to open the file by repairing or removing the unreadable contnet. Removed records: Style from /xl/styles.xml part (Styles) Removed Records: Format from /xl/styles.xml part (Styles) and as you can guess from the error message the spreadsheet is stripped of all the formatting finance have done on the spreadsheet, this is quit unacceptable for them as the formatting means as much as the data inside of it does... eg red is high priority, green is low priority ect. Can anybody suggest to me a way to fix this problem? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try NOT using two instances.
Marvin B wrote: Hi all, I've currently got a problem with the Excel 2007. i'll try to describe the problems as i found them. Customer service has 2 seperate instances of Excel open, they copy from one xlsx spreadsheet to another xlsx spreadsheet (seperate instances) the first time they copy somehting it works fine the second time they copy somehting it will coppy the cell structure, but the content will be empty from this i thought it might have been a clipboard error, but the clipboard works perfectly well in most cases. I asked around the office if this happened to anyone else, and it hasen't so i tried looking at why... We've recently updated from office 2003 to office 2007 and customer service is one of the few sections that have updated their spreadhseets to Excel 2007, this isn't unique but they are the only ones that are copying from a converted excel document into another converted excel document. After the user playign around for a bit he found out that it took maybe 20 copy / pastes between the 2 instances of Excel before one of them would corrupt. When it corrupts it comes up with this message Excel found unreadable content in 'MyExcelDocument.xlsx', Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes. Clicking no will stop everything, clicking Yes will bring up a further error message box with Repais to ''MyExcelDocument.xlsx' Excel was able to open the file by repairing or removing the unreadable contnet. Removed records: Style from /xl/styles.xml part (Styles) Removed Records: Format from /xl/styles.xml part (Styles) and as you can guess from the error message the spreadsheet is stripped of all the formatting finance have done on the spreadsheet, this is quit unacceptable for them as the formatting means as much as the data inside of it does... eg red is high priority, green is low priority ect. Can anybody suggest to me a way to fix this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why isn't my paste function working properly in Excel? | Excel Discussion (Misc queries) | |||
Hyperlink in csv file not working properly | Excel Discussion (Misc queries) | |||
Macro not working properly when the file is shared | Excel Worksheet Functions | |||
Copy paste in excel dont work properly | Excel Discussion (Misc queries) | |||
Excel Doesn't Copy / Paste Properly in other Applications | Excel Discussion (Misc queries) |