| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Password Protected Excel Spreadsheet opens blank
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 |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Password Protected Excel Spreadsheet opens blank
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 |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Password Protected Excel Spreadsheet opens blank
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 |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Password Protected Excel Spreadsheet opens blank
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 |
|
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Password Protected Excel Spreadsheet opens blank
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 |
|
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Password Protected Excel Spreadsheet opens blank
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to access protected spreadsheet without the password? | Excel Discussion (Misc queries) | |||
| Forgot password on protected Excel spreadsheet . . change? | Excel Worksheet Functions | |||
| Can a Works spreadsheet be password protected? | New Users to Excel | |||
| How do I unlock a spreadsheet that is password protected? | Excel Worksheet Functions | |||
| password protected certain cells in spreadsheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
