Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
LisaK
 
Posts: n/a
Default Can't open existing file

Excel 2002 workbook - approx. 84K in size. Last saved 4/13/06. Click on
file name to open today, 4/18/06. What I get is the Excel screen with some
of the tool bar area greyed out, no workbook or even a worksheet showing, and
most of the menu items greyed out. Any ideas what happened to this file?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default Can't open existing file

If it opens okay when you do a File, Open from Excel's menus, make sure you
do not have Ignore other Applications selected under Tools, Options,
General.

--
Jim
"LisaK" wrote in message
...
| Excel 2002 workbook - approx. 84K in size. Last saved 4/13/06. Click on
| file name to open today, 4/18/06. What I get is the Excel screen with
some
| of the tool bar area greyed out, no workbook or even a worksheet showing,
and
| most of the menu items greyed out. Any ideas what happened to this file?


  #3   Report Post  
Posted to microsoft.public.excel.misc
LisaK
 
Posts: n/a
Default Can't open existing file

Thanks for the suggestion. It made me realize I hadn't tried to open this
file from within Excel, that I'd only tried opening it via Windows file
manager. That said, it's the same story. If I open Excel, then find the
file via File Open, the program goes through the motions as though it is
opening the file . . . it asks if I want to update links, I either accept or
not, then the program continues on with the file open process. But nothing
shows up on the screen. I am left looking at the default Book1. If I close
Book1, I am left with the basic Excel program screen, no open workbooks.
HOWEVER . . . when I exit Excel, it asks me if I wish to save changes to the
file I tried to open as though it is open on my screen. But it isn't. I
can't see the file, there's no open workbooks apparent.

I checked the Tools Option you suggested, but Ignore Other Applications was
not selected.

-LLK


"Jim Rech" wrote:

If it opens okay when you do a File, Open from Excel's menus, make sure you
do not have Ignore other Applications selected under Tools, Options,
General.

--
Jim


  #4   Report Post  
Posted to microsoft.public.excel.misc
LisaK
 
Posts: n/a
Default Can't open existing file

Responding to myself here . . . problem may be link related. This Excel file
is linked to a Word file. It started misbehaving after the last update to
the Word file. I have restored the previous save of the Excel file and can
now access data. However, after the file opens, a warning that the same file
using same name is open already appears. I don't know why the file doesn't
open as read only if that is the case. I believe the warning is to make one
aware that a file by the same name exists in a different folder and that
there may be a conflict. But when I search the entire directory [D: drive],
there is no file by the same name in any of the folders or subfolders.

I'll continue to dig. If anyone has any ideas about file open conflicts
with linked files [Word<-Excel], let me know!

-LLK

"LisaK" wrote:

Excel 2002 workbook - approx. 84K in size. Last saved 4/13/06. Click on
file name to open today, 4/18/06. What I get is the Excel screen with some
of the tool bar area greyed out, no workbook or even a worksheet showing, and
most of the menu items greyed out. Any ideas what happened to this file?

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 Outlook Attachments opening after several errors everytime cito_support Setting up and Configuration of Excel 2 March 13th 06 06:15 PM
Cannot open an XLS file. ntwiz2 Excel Discussion (Misc queries) 4 March 1st 06 09:06 PM
Open an existing excel speadsheet, opens Excel but not the file?? Smeeta Geary Excel Discussion (Misc queries) 1 September 19th 05 03:28 PM
cannot open excel file, please help!!! sunlite Excel Discussion (Misc queries) 0 September 5th 05 05:29 PM
Cannot open a file that Excel says is open Plodhia Excel Discussion (Misc queries) 2 December 7th 04 01:43 AM


All times are GMT +1. The time now is 07:20 PM.

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"