How do I view the content of my opened worksheet

  • Thread starter Guy Philippe Mfegue
  • Start date
G

Guy Philippe Mfegue

Dear all,

I have a problem a colleague submitted to me concerning
an Excel worksheet; this worksheet opens with Excel but
nothing is displayed (only a grey background) but you can
see the name of the file on top of the Excel windows,
showing that the file is opened.
Using an importation with Access convinced me that the
data are ok in the worksheet. This leads me to conclude
that there is something (may a macro) that hides
automatically the content of the worksheet once it ends up
opening.
Please help me asap, as we need this worksheet for end of
year closing works.
Many thanks in advance.

All the best
= GPM
 
F

Frank Kabel

Hi
does the same happen if you open the file within Excel with 'File -
Open'?
 
G

Guest

Absolutely yes. Even using 'File- 'Open'... the same
problem occurs.
Thanks in advance for the help.
=GPM
 
I

icestationzbra

if you suspect that a macro is the culprit, with the worksheet open, hi
Alt+F11. a VB editor window should open up. scan through the contents t
see if there is any code. on the left pane, various sheets within th
workbook should be listed. click on each of these sheets individulall
and view the right pane. if there is something in the right pane, past
the contents here and someone will take a look at them for you. all thi
assuming that the code is not protected with a password
 
I

icestationzbra

just to rule out any possibility of macros being involved, go over t
Tools - Macro - Security. select either High or Medium. if you selec
High, the macro will not be triggered when you open your workbook. i
you select Medium, you will be asked to either Enable or Disable macro
when you open the workbook. choose to Disable (if you select Medium)
now open the workbook. if you still see no difference, then macros ar
not involved is this bermudian disapperance of data
 
L

Lady Layla

In Excel go to Window and select Arrange Tiled. See if this brings it up.


: Dear all,
:
: I have a problem a colleague submitted to me concerning
: an Excel worksheet; this worksheet opens with Excel but
: nothing is displayed (only a grey background) but you can
: see the name of the file on top of the Excel windows,
: showing that the file is opened.
: Using an importation with Access convinced me that the
: data are ok in the worksheet. This leads me to conclude
: that there is something (may a macro) that hides
: automatically the content of the worksheet once it ends up
: opening.
: Please help me asap, as we need this worksheet for end of
: year closing works.
: Many thanks in advance.
:
: All the best
: = GPM
 
Top