Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

ACCESS WORKBOOKS AND RIBBON ON SAME SCREEN

0

We have an Excel 2007 spreadsheet that uses 7 or 8 workbooks.  The problem is we can only see which workbook we want to use - but the ribbon is not visible. We know about using VIEW and Full screen to see the workbooks and right clicking above where the ribbon should be and choosing RESTORE to see the ribbon.  We want both to be visible on the same screen. They are when using a different computer but not on the PC we are using which is an Acer Netbook. Can you help? I think it is just a few mouseclicks but which ones is a mystery.

Larry K

excel
MS Office Version: Excel 2007
posted by: ldkamb on Wed Feb 23, 2022 at 1:12 pm
Answer
Discuss

Discussion

Please dont make your title in all caps!
don (rep: 1989) Feb 23, '22 at 6:53 pm
Add to Discussion

Answers

0

Hi Larry and welcome to the Forum.

You didn't attach any files to your question for us to look at (and my netbook is not working at present) but I suggest you first check the version of Excel running on the Acer Netbook (though we've had the ribbon since Excel 2007).

I don't have a copy of Excel 2007 any longer but perhaps your remote user has clicked Crtl+F1 accidentally- this collapses (or restores) the ribbon- try that. Furthermore if the option "Collapse the ribbon automatically" was set (under menu File/Options... /General/User Interface options in Excel 365 for example), then the ribbon would disappear once you clicked away from the ribbon (in the worksheet) but the ribbon would return if you clicked a ribbon heading like View in the menu bar.

Another thing to check is that the files aren't protected by the VBA method in Don's tutorial Completely Hide the Ribbon Menu in Excel (though you might also get something from another: Hide the Excel Interface and Show Only Data)

It could be sadly that the limitations of the Acer Netbook's resources (RAM etc.) just aren't adequate to support several screens, especially if the files are large. I guess you've tried running it with no other apps running (and disabling whatever services can). 

posted by: John_Ru (rep: 6142) on Wed Feb 23, 2022 at 2:06 pm
Discuss

Discussion

Larry. I now see that you asked a similar question here in 2020 Excel 2007 not displaying as expected. What happened there please? 
John_Ru (rep: 6142) Feb 23, '22 at 5:16 pm
John_Ru,
Thanks for responding. With regard to my older post in 2020, the suggested fix did work. During this current episode, it did not make any difference. Show sheet tabs is checked. The file we are working with is only 234KB so that isn't it. The Acer has been in use for many years with no such issues except for the previous post. We know the system is capable of displaying both the ribbon and the workbooks but due to some errant mouseclick (thats my guess) it no longer does so. Just FYI, the person I am helping is in VA whereas I am in WA State. We use TeamViewer as I try to get her back on track. The Excel Version is: Excel 2007 (12.0.6787.5000). Any other suggestions would be appreciated.
Larry
ldkamb Feb 23, '22 at 8:28 pm
Thanks Larry. I've revised my Answer - see suggestions in the new second main paragraph. I suspect Ctrl+F1 is the cause but over to you. I guess you've tried right-click in the ribbon area and unticking/unchecking Collapse the Ribbon (or whatever Excel 2007 says).

If that doesn't help, I can't think of anything else, sorry. Perhaps someone else will come to you/her rescue.
John_Ru (rep: 6142) Feb 24, '22 at 6:55 am
p.s. Don't forget to edit your question title (as Teach Excel founder Don suggested in response)- no one likes to be "shouted" at online and that includes me!
John_Ru (rep: 6142) Feb 24, '22 at 6:57 am
John,

The problem is solved. Ctrl+F1 worked. That was going to be my Plan A solution. However, when she went to bed she turned the computer off.  The next day (today) she turned it on and when she loaded the file she was having the problem with, it came up perfectly. No mouse or keyboard required.  The old adage of Turn it off and turn it back on really works in many cases.  So Ctrl+F1 is our new Plan B when it happens again.  Thanks very much.  Take the rest of the day off!

Larry
ldkamb Feb 24, '22 at 4:26 pm
Cheers Larry! If that worked, kindly select my Answer (for the guidance of others and to nudge ny reputation up a little)

Please don't forget to edit your question title (I can't) 
John_Ru (rep: 6142) Feb 24, '22 at 4:32 pm
When I saw the title of this post it caught my interest (despite being all caps). When reading the details I came to the same conclusion as John did - it had to do with the settings on the notebook. I use a 10yr+ old Acer laptop with Office 2007 and have never had any issues with any file (2003 - Office365).
WillieD24 (rep: 557) Feb 24, '22 at 9:13 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login