Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting office excel 2007 to excel 2003 | New Users to Excel | |||
exporting to excel 2003 | Excel Worksheet Functions | |||
Excel 2003 compatibility | Excel Discussion (Misc queries) | |||
Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |