Solved

2003 Excel Workbook appears to open but isn't there

Posted on 2013-11-26
8
283 Views
Last Modified: 2013-11-26
I have a 2003 Excel workbook that won't open, exactly.  When you open it the user is asked about enabling macros and the choice to update the links is offered but it's not there.  If you click on the Window button in the task bar it doesn't show it.  In the network system where we use the workbook, if you try to open it again on a different computer you get a message telling you that it's already open and you have the choice of Read Only, Notify, etc. If you click Read Only it doesn't come up either but supposedly it's open on the other computer that didn't show it.  For business reasons I cannot attach the file.
0
Comment
Question by:RogerKMiller
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 15

Expert Comment

by:ChloesDad
ID: 39678757
Can the file be opened successfully if it is copied to a local disk drive and opened from there?
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39678826
Is it visible in VBA project explorer?
0
 
LVL 4

Expert Comment

by:LCCSAM
ID: 39678884
How big is the file?
It may be that the computer you are using is taking a long time to process the data. I would leave it open a few minutes to see if it will open for you.

Often on our older computers the larger spreadsheets (100's of thousands of lines) will take 5-10 minutes to open.
0
 

Author Comment

by:RogerKMiller
ID: 39679081
1. Transferring the workbook leads to the same effect, not visible.  I transferred it using Team Viewer to my laptop.  Same problem.

2. In VBA project explorer it will show the actual names of the sheets (daily names) but won't show the sheets.  but it also shows "This workbook" to be Book1 with the standard 3 sheets.  I have a macro in this workbook which will run until the macro starts to look for a sheet name like "Wednesday", the first sheet.  It then goes into debug as the sheet can't be found; however, there is a variable which selects the first digit of the workbook and that variable, when in debug, shows the correct digit when floating the cursor over it.

3. The file is only 2.5 MB and on my fairly new laptop I have the same problem.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 15

Accepted Solution

by:
ChloesDad earned 500 total points
ID: 39679104
Is the macro hiding the workbook so that it is not displayed?

look for something like

workbook.visible=false

If not then try and set the workbook.visible=true
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39679339
In 2007 you should be able to get around this by

View > Window > Unhide

Try something similar in 2003
0
 
LVL 80

Expert Comment

by:byundt
ID: 39679556
A Workbook object doesn't have an Unhide method or Visible property. But the Window object containing the workbook does have a Visible property.

The following macro will make all windows visible. Put it in a regular module sheet in any open workbook, and run it from the ALT + F8 macro selector.
Sub Fenestration()
Dim win As Window
For Each win In Application.Windows
    win.Visible = True
Next
End Sub

Open in new window

0
 

Author Closing Comment

by:RogerKMiller
ID: 39679598
I thought I already closed this out saying that ChloesDad's comment about the macro led me to look for an Unhide command and found it in the Window tool button.  This solved the problem thanks to ChloesDad's tip.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now