Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Someone else posted on this last year, but no replies. This error message comes up if I try to open an Excel file from Explorer, rather than from Excel itself (File/Open). I'm using Excel 2000 (9.0.6926 SP3). If I get rid of the error message by clicking OK, it reappears a couple of times, then I get Excel shown, showing the name of the file in the window caption bar - also, the contents of A1 are shown in the whatdjewcallit editing toolbar. But the spreadsheet is completely blank, and Excel doesn't respond to any mouse or keyboard input. Opening it through Excel (File/Open) is fine. Also, double-clicking from Explorer works fine, AS LONG AS there's an instance of Excel already running (it opens in that instance). Saving the file again, or making a nonsense change to a cell and then saving it, makes no difference. This is a file created from Access VBA through the Excel 9.0 COM objects. Other files created in this way don't have this problem. There's no workaround, Access has to create this file in this way; and there's nothing at all in the MS KB. Anyone have any ideas? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've never seen this phenomenon but since the workbook opens fine from File,
Open it would seem to be a problem with Excel versus the workbook itself. The only thing I can suggest is that you have Excel re-register itself in case there is something not right with its file associations. From Start-Run enter "Excel.exe /regserver" (no quotes, there is a space before the slash). If that doesn't help there is the old fallback, reinstalling Excel. That seldom fixes anything though. -- Jim "sebt" wrote in message oups.com... | Hi | | Someone else posted on this last year, but no replies. | | This error message comes up if I try to open an Excel file from | Explorer, rather than from Excel itself (File/Open). I'm using Excel | 2000 (9.0.6926 SP3). | | If I get rid of the error message by clicking OK, it reappears a couple | of times, then I get Excel shown, showing the name of the file in the | window caption bar - also, the contents of A1 are shown in the | whatdjewcallit editing toolbar. But the spreadsheet is completely | blank, and Excel doesn't respond to any mouse or keyboard input. | | Opening it through Excel (File/Open) is fine. Also, double-clicking | from Explorer works fine, AS LONG AS there's an instance of Excel | already running (it opens in that instance). | | Saving the file again, or making a nonsense change to a cell and then | saving it, makes no difference. | | This is a file created from Access VBA through the Excel 9.0 COM | objects. Other files created in this way don't have this problem. | There's no workaround, Access has to create this file in this way; and | there's nothing at all in the MS KB. | | Anyone have any ideas? | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Pasting Data | Setting up and Configuration of Excel | |||
Null values in charts and how to override the goal seek functionality | Charts and Charting in Excel | |||
Multipying columns that contail null values | Excel Discussion (Misc queries) | |||
Excel pointer problem | Excel Worksheet Functions | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |