Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Error when copying from spreadsheets in Office 2007

I have two users. One has Windows XP Pro with Office 2007 and the other has
Windows Vista Ultimate with Office 2007. They both experience an issue when
they open up multiple instances of Excel (so that they can display a
spreadsheet on both monitors) and while copying back and forth between the
spreadsheets. After opening the file (after doing all the copying) they will
get the error: "Excel was able to open the file by repairing or removing the
unreadable content." Then in the body of the error "Removed Records: Style
from /xl/styles.xml part (styles)" This is saving in the .xlsx format.

When saving it in the .xls format they receive this error: "Excel recovered
your formulas and cell values, but some data may have been lost".

Lots of data is being lost when this happens - any suggestions? Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Error when copying from spreadsheets in Office 2007

I don't have a guess, but if multiple monitors is the only reason to use
multiple instances, you may want to review Chip Pearson's notes:

http://cpearson.com/excel/MultipleMonitors.aspx



Courtney Hill wrote:

I have two users. One has Windows XP Pro with Office 2007 and the other has
Windows Vista Ultimate with Office 2007. They both experience an issue when
they open up multiple instances of Excel (so that they can display a
spreadsheet on both monitors) and while copying back and forth between the
spreadsheets. After opening the file (after doing all the copying) they will
get the error: "Excel was able to open the file by repairing or removing the
unreadable content." Then in the body of the error "Removed Records: Style
from /xl/styles.xml part (styles)" This is saving in the .xlsx format.

When saving it in the .xls format they receive this error: "Excel recovered
your formulas and cell values, but some data may have been lost".

Lots of data is being lost when this happens - any suggestions? Thanks.


--

Dave Peterson
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
Excel 2007 spreadsheet references older office spreadsheets NuclearNed Excel Discussion (Misc queries) 2 June 29th 09 02:52 PM
Copying data across a workbook -- Office 2003 vs 2007 RonH Excel Worksheet Functions 1 February 8th 09 10:49 PM
Office 2007 install corrupted excel spreadsheets? fox_mulder33[_2_] Setting up and Configuration of Excel 0 January 24th 08 03:57 PM
Error message when copying Excel Pie Chart to Word (in Office 2007 Market1 Charts and Charting in Excel 0 December 12th 07 06:01 PM
office 2007 opening multiple files in error Jim Excel Discussion (Misc queries) 0 October 23rd 07 05:16 PM


All times are GMT +1. The time now is 03:37 AM.

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

About Us

"It's about Microsoft Excel"