Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel Copy, Paste not working properly, corrupts file

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Excel Copy, Paste not working properly, corrupts file

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why isn't my paste function working properly in Excel? trainer07 Excel Discussion (Misc queries) 2 October 19th 07 06:09 PM
Hyperlink in csv file not working properly TracyM Excel Discussion (Misc queries) 1 April 26th 07 06:36 PM
Macro not working properly when the file is shared Chakri Excel Worksheet Functions 0 August 30th 06 01:33 PM
Copy paste in excel dont work properly [email protected] Excel Discussion (Misc queries) 0 December 30th 05 09:57 AM
Excel Doesn't Copy / Paste Properly in other Applications Glenn Excel Discussion (Misc queries) 1 July 13th 05 05:39 PM


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"