LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 385
Default Exporting to Excel 2003

Our business has an application that we use for business planning purposes.
One of its functions is to export the numbers in the grid to an Excel
spreadsheet. I think what happens behind the scene is that the gris is saved
in an XML file, which is then loaded into Excel. Anyway, this has always
worked correctly with Excel 2000. Since an upgrade to 2003, this is failing
at certain times. It is failing specifically when there is some text in the
grid. For example, a percentage might show as "NaN" in some cases. Excel
tries to open the grid and returns an error. The message box says "Problems
came up during load: The file cannot be opened because of errors." It seems
to me that Excel is trying to put text into a number field and doesn't know
what to do with it. I'm wondering if there is some setting in Excel 2003
that can be changed to allow this.

Thanks!
 
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
converting office excel 2007 to excel 2003 nctarheel New Users to Excel 1 February 3rd 07 09:16 PM
exporting to excel 2003 cheerleader Excel Worksheet Functions 2 January 29th 07 11:17 PM
Excel 2003 compatibility Alain Excel Discussion (Misc queries) 0 June 23rd 06 11:02 AM
Merging cells in Excel 2003 Bob Excel Discussion (Misc queries) 1 October 19th 05 07:10 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM


All times are GMT +1. The time now is 10:49 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"