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 |
#8
Posted to microsoft.public.excel.setup
|
|||
|
|||
Password Protected Excel Spreadsheet opens blank
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 |
#9
Posted to microsoft.public.excel.setup
|
|||
|
|||
Password Protected Excel Spreadsheet opens blank
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 |
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) |