Password Protected Excel Spreadsheet opens blank

Enter the correct password but the spreadsheet is blank and grey in color,
does not display anything. Opening it in Read Only Mode.

Any help would be appreciated.

thanks in advance

Are you sure the workbook is opening?

If you do file|print preview, do you see anything?

If yes, then maybe the viewable area is just off the screen.
Window|arrange|tiled (and resize manually)
(excel 2003 menus)

Neil wrote:

Enter the correct password but the spreadsheet is blank and grey in color,
does not display anything. Opening it in Read Only Mode.

Any help would be appreciated.

thanks in advance

--

Dave Peterson

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 12:14:16 -0700, Neil wrote:

Enter the correct password but the spreadsheet is blank and grey in color,
does not display anything. Opening it in Read Only Mode.

Any help would be appreciated.

thanks in advance

Gord & Dave,

Thanks for your reply. Actually the file resides on a network share and it
is password protected. I enter the password and it shows at the bottom
opening the file 12345.xls and then it goes into Ready state.

I tried reregistering as per your instructions but still no change. The file
is actually on a NAS (FILE SERVER).

Again I thank you for your help, hope the above information adds some more
insight.



"Gord Dibben" wrote:

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 12:14:16 -0700, Neil wrote:

Enter the correct password but the spreadsheet is blank and grey in color,
does not display anything. Opening it in Read Only Mode.

Any help would be appreciated.

thanks in advance

And when you did File|Print preview, what happened?

Neil wrote:

Gord & Dave,

Thanks for your reply. Actually the file resides on a network share and it
is password protected. I enter the password and it shows at the bottom
opening the file 12345.xls and then it goes into Ready state.

I tried reregistering as per your instructions but still no change. The file
is actually on a NAS (FILE SERVER).

Again I thank you for your help, hope the above information adds some more
insight.

"Gord Dibben" wrote:

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 12:14:16 -0700, Neil wrote:

Enter the correct password but the spreadsheet is blank and grey in color,
does not display anything. Opening it in Read Only Mode.

Any help would be appreciated.

thanks in advance



--

Dave Peterson

Print option is greyed out, cannot choose it to preview.



"Dave Peterson" wrote:

And when you did File|Print preview, what happened?

Neil wrote:

Gord & Dave,

Thanks for your reply. Actually the file resides on a network share and it
is password protected. I enter the password and it shows at the bottom
opening the file 12345.xls and then it goes into Ready state.

I tried reregistering as per your instructions but still no change. The file
is actually on a NAS (FILE SERVER).

Again I thank you for your help, hope the above information adds some more
insight.

"Gord Dibben" wrote:

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 12:14:16 -0700, Neil wrote:

Enter the correct password but the spreadsheet is blank and grey in color,
does not display anything. Opening it in Read Only Mode.

Any help would be appreciated.

thanks in advance



--

Dave Peterson

Did you try the other suggestion from Gord?

Can you open the file by opening excel first and then File|Open?

You may want to give more details on how you're trying to open the workbook.

Neil wrote:

Print option is greyed out, cannot choose it to preview.

"Dave Peterson" wrote:

And when you did File|Print preview, what happened?

Neil wrote:

Gord & Dave,

Thanks for your reply. Actually the file resides on a network share and it
is password protected. I enter the password and it shows at the bottom
opening the file 12345.xls and then it goes into Ready state.

I tried reregistering as per your instructions but still no change. The file
is actually on a NAS (FILE SERVER).

Again I thank you for your help, hope the above information adds some more
insight.

"Gord Dibben" wrote:

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 12:14:16 -0700, Neil wrote:

Enter the correct password but the spreadsheet is blank and grey in color,
does not display anything. Opening it in Read Only Mode.

Any help would be appreciated.

thanks in advance



--

Dave Peterson


--

Dave Peterson

I tried opening the spreadsheet directly from the network location. I also
tried opening the spreadsheet by opening Excel on my machine and then
choosing File / Open. It opens and asks for the password. I enter the
password and open it in Read Only mode and it shows it is Opening
filename.xls and then it goes into Ready mode and does not open up the file.
The screen is empty. But, we restored a file from the backup and that opened
properly.

The file size is same as the one which was restored infact little more as
there was data that was entered for the last 2 days. So, I have requested
them to add the 2 days data but as you know administration wants only that
file, which I am not sure what cause the file not to open. But, it might be
corrupt.

Any other solutions?

"Dave Peterson" wrote:

Did you try the other suggestion from Gord?

Can you open the file by opening excel first and then File|Open?

You may want to give more details on how you're trying to open the workbook.

Neil wrote:

Print option is greyed out, cannot choose it to preview.

"Dave Peterson" wrote:

And when you did File|Print preview, what happened?

Neil wrote:

Gord & Dave,

Thanks for your reply. Actually the file resides on a network share and it
is password protected. I enter the password and it shows at the bottom
opening the file 12345.xls and then it goes into Ready state.

I tried reregistering as per your instructions but still no change. The file
is actually on a NAS (FILE SERVER).

Again I thank you for your help, hope the above information adds some more
insight.

"Gord Dibben" wrote:

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 12:14:16 -0700, Neil wrote:

Enter the correct password but the spreadsheet is blank and grey in color,
does not display anything. Opening it in Read Only Mode.

Any help would be appreciated.

thanks in advance



--

Dave Peterson


--

Dave Peterson

If the file isn't really opening, then maybe starting excel in safe mode:

close excel
windows start button|Run
excel /safe

And file|open your workbook.

If it works there, then maybe there's a "helpful" macro that is closing the
workbook???

Neil wrote:

I tried opening the spreadsheet directly from the network location. I also
tried opening the spreadsheet by opening Excel on my machine and then
choosing File / Open. It opens and asks for the password. I enter the
password and open it in Read Only mode and it shows it is Opening
filename.xls and then it goes into Ready mode and does not open up the file.
The screen is empty. But, we restored a file from the backup and that opened
properly.

The file size is same as the one which was restored infact little more as
there was data that was entered for the last 2 days. So, I have requested
them to add the 2 days data but as you know administration wants only that
file, which I am not sure what cause the file not to open. But, it might be
corrupt.

Any other solutions?

"Dave Peterson" wrote:

Did you try the other suggestion from Gord?

Can you open the file by opening excel first and then File|Open?

You may want to give more details on how you're trying to open the workbook.

Neil wrote:

Print option is greyed out, cannot choose it to preview.

"Dave Peterson" wrote:

And when you did File|Print preview, what happened?

Neil wrote:

Gord & Dave,

Thanks for your reply. Actually the file resides on a network share and it
is password protected. I enter the password and it shows at the bottom
opening the file 12345.xls and then it goes into Ready state.

I tried reregistering as per your instructions but still no change. The file
is actually on a NAS (FILE SERVER).

Again I thank you for your help, hope the above information adds some more
insight.

"Gord Dibben" wrote:

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 12:14:16 -0700, Neil wrote:

Enter the correct password but the spreadsheet is blank and grey in color,
does not display anything. Opening it in Read Only Mode.

Any help would be appreciated.

thanks in advance



--

Dave Peterson


--

Dave Peterson


--

Dave Peterson