The attached pic should help in the explanation. My data is stuck at the bottom of my screen as if it was another open window. I don't know how it happened or how to fix it. I tried simply dragging it but that doesn't work, and I don;t know what setting to change to fix it. Can someone please help me?? Thank you!!
Hi dumaser88 and welcome to the forum.
Try these.
Double click on the top of your spreadsheet that is out of view.
Or click and drag it back into view using the top of the spreadsheet.
Also try the shortcut keys of Alt +W +A
Last edited by MarvinP; 04-14-2011 at 12:54 AM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
tried your suggestions but still no luck
the top of the sheet partially in view stays grayed out and will not allow me to select it or drag or click on it in any way.......
Click on the View Tab at the top of you screen. Then Arrange All and try those selections.
make sure workbook is topmost
then alt+ - thats hold alt press minus
now press m
use down arrow key to move workbook
left click when moved down to release workbook
Last edited by martindwilson; 04-15-2011 at 02:12 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
that didn't work either..... I'm thinking all hope is lost.....
If I switch to full screen mode, I can see enough of the screen to use the arrow to view a little more of the data, but I still cannot get back to the normal view or even see the bottom section to switch between workbooks. I'm getting desperate lol
If anyone would be willing I will even email you the damaged file if you think it can be saved. It's nothing but a work schedule and has no personal info.... any takers?
Click on Go Advanced below the message area and then on the Paper Clip Icon above the message area to attach a file. Let us look. Maybe you'll teach us something.
in "window" on the tool bar did you select the workbook you want to get? did you try arrow up? alt - should show the move /size/minimise/maximise/close window
m just selects the move option, arrow moves the window
oh a fun duplicate posting day on the forum!
thanks for the help so far everyone. I have the file attached so feel free to take a look.
The workbook has the Structure and Window protected.
Using the ribbon, Review > Changes > Protect Workbook > Protect Structre and Window.
You will of course need the password.
i just opened it in open office, that fixed it
I wonder who protected this workbook?
Here it is..
Opened it with Open Office?
That would be the non-microsoft product?
yep works a treat lol
Sounds like a legal question. MSFT should have a problem with the other guys undoing that protect featrue?
i think it was just corrupt it opens ok in google docs as well
Last edited by martindwilson; 04-19-2011 at 01:20 PM.
I think it had workbook security on and the OP just needed the workbook protect password to deal with it.
awesome! thanks everyone for the help
sorry it took me a while to get back here and check, but I appreciate it guys.
This resolution assumes it is just ONE corrupt workbook but ALL my workbooks are doing this same thing. Are you telling me that instead of using excel which i pay for monthly i must now use a Free Access product instead to fix this problem?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks