Never had any problem with that worksheet when working on good old Office 2003. Click on the “View” tab, then click on the button “View Side by Side”. If you close down Excel 2007 afterwards, can you then open that file directly by clicking?If not, what error messages do you get?Mark Flag Permalink This was helpful (0) Collapse – Fixed it for me.
Can't See Tabs In Excel
I was really stuck for a while =). Felix Atagong Says: Tuesday, 26th March, 2013 at 11:44 am | Reply I receive a daily file per mail from a client and this behaviour really drove me nuts. File/Options/Advanced/Display/Show Sheets box is checked but sheets are hidden except in FullScreen vieweditNot sure what I did but after unchecking and rechecking I maximized the window and all my sheets appeared. Thank you!
I use Excel 2003 0Votes Share Flag Collapse – Solution by jfrago · 9 years ago In reply to excel won’t show spreadsh … I believe this problem was generated by an excel document that was created in earlier versions of excel, and opened in compatibility view. Isabel Says: Tuesday, 23rd August, 2011 at 10:08 pm | Reply The same thing just happend to me right now and what I did was go to VIEW then I selected Excel Worksheet Tabs I tried different views, nothing to do.
This document, titled “Windows 7 – unable to open Excel files,” is available under the Creative Commons license. I get the Excel window box and toolbars, but the worksheet doesn’t draw. Thanks (0) By David Ringstrom Jun 26th 2015 01:12 http://www.accountingweb.com/a… %livelink2% Restoring the Excel window (so it is not maximized) then moving it and resizing (making it bigger) until you find it usually does the trick.
Thought I lost a HUGE file. Excel File Open But Not Visible Once I opened a file, I could hit the Office Button to make my worksheet appear. For more information, see Worksheet tabs disappear when you change some “Display options for this workbook” options and then add a macro worksheet to a workbook in Excel 2007. Thanks (0) By Eben Samuel Jun 26th 2015 01:11 works awesom!
Excel Workbook Tabs
To unhide a worksheet, right-click on any visible tab on the worksheet, and then click Unhide. %livelink3% If you are working with roaming profiles you will need to do the same under c:\documents and settings\username\application data\microsoft\excel\xlstart\ Delte this file from both locations. Can't See Tabs In Excel Thanks (0) By David Ringstrom Jun 26th 2015 01:11 I’m so glad! Excel Worksheet Disappeared The window is minimized off you viewable screen.
Doh! It will open anything normally from its own File|Open command.Files are associated properly; version is office 2000 SP-3, and it has been repaired and then reinstalled, and still does the same Still, this is stupid behavior, all too typical of MS. The Show sheet tabs setting is turned off. Excel Sheet Tabs Hidden Behind Taskbar
gypcjes Says: Friday, 29th May, 2009 at 7:18 pm | Reply Yes, I am having this issue right now and it is driving me CRAZY! by Kees Bakker / June 15, 2009 8:09 PM PDT In reply to: Unable to open Excel 2003 files directly by clicking on the but apparently isn’t.Things to try:1. Related This entry was posted on Tuesday, 17th March, 2009 at 6:05 pm and is filed under error, Excel, Spreadsheet. Thanks (0) By David Ringstrom Jun 26th 2015 01:11 I’m glad to hear that.
Craig Says: Wednesday, 22nd August, 2012 at 2:20 pm | Reply The way I fixed it for me was to click the “View” tab, then in the ‘window’ area click the Unhide Tabs In Excel 2010 Also, it was one specific spreadsheet (it had macros in it) that would not display. Your suggestion is a good one, but I think would rather create a new workbook than a new window, then tile.
Excel is set to ignore other applications The most common cause is that Excel has been configured to ignore other applications.
Simon Says: Thursday, 19th March, 2009 at 2:35 pm | Reply Jayson never close window 1: and you won’t lose zoom settings I have heard elsewhere about resizing the Excel window, Kevin Finn Says: Tuesday, 21st September, 2010 at 5:25 pm | Reply If it helps, I found another way trigger and then fix this issue. You saved me! Can't See Tabs In Excel Mac cheers Simon Like this:Like Loading…
In Excel 2007, select the Review tab, then click the Protect Workbook button and uncheck Protect Structures and Windows. Many thanks!!! If you’re new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. To disable this option you can do the following; Excel 2003 and previous Tools-> Options…-> tab General-> option: Ignore other applications Excel 2007 Office logo (left top)-> Excel Options-> section Advanced->
Close it by clicking the red “X” in the top right hand corner. It worked for me. If you still don’t see the tabs, click View > Arrange All > Tiled > OK. Open a fresh new window.
I cannot move it around, more can I maximize it to use the full size of the screen anymore. Jayson Says: Friday, 20th March, 2009 at 3:11 pm | Reply I am using Ultramon. Thanks (0) Pages1 2 next › last » Please login or register to join the discussion. You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.
Abhra Says: Wednesday, 20th July, 2011 at 10:53 am | Reply Close the excel file. Thanks (0) By Jim Jun 26th 2015 01:11 You are a great mentor! It goes away if you fiddle around long enough. Really helpful.
The other “fixes” did not work at all! try view arrange too and try this stuff https://smurfonspreadsheets.wordpress.com/2009/04/14/excel-2007-screen-video-issues/ cheers Simon let us know how you get on Andrew Says: Tuesday, 9th March, 2010 at 11:03 pm | Reply Ahh dude, I am working with 2 computers while I transition off the older to the newer one. Thanks (0) By David Ringstrom to msliz Jun 26th 2015 01:11 Darryl, At this point I’d need to see your spreadsheet.
My solution in Excel 2003 was: -Open the problem file -Open a new workbook -‘Restore’ the new workbook so as it isn’t full screen -Right click the top bar of the If this happens, your “missing” worksheets may be hiding in plain sight due to a simple Excel setting. As a paper coordinator of several distance papers that use excel workbooks for assignments, I often have to help students who have ‘lost ‘ the tabs. I hope someone can PLEASE help me with this.