Results 1 to 3 of 3
  1. #1

    Member Since
    Dec 12, 2010
    Excel 2008 and 2011 file
    I am trying to convert a file from Excel 2008 to Excel 2011. The file is a workbook with 26 sheets in it. I open it up in Excel 2011 and an error message opens and says that it must convert the workbook to a chart table. I accept the change. The problem is all the sheets normally located at the bottom of the workbook are gone. The workbook opens on a sheet and that is the only sheet I can view. Any ideas on how to change it from a chart table work book back to a work book with all 26 sheets at the bottom? I need to inter change between sheets? Each sheet has different data. There probably is an easy fix that I just don't know about.

    Is there any way to recover or change it back so I can view all 26 sheets???
    Please help thanks

  2. #2

    Buzzard2010's Avatar
    Member Since
    Oct 22, 2010
    Bretforton, Worcestershire
    MacBook Pro 15" 2014, 2.2GHz i7, 16GB RAM, 250GB SSD, OSX 10.9.5 - iPhone 5s 16gb
    I know this isn't a convert fix, but have you tried to create a new workbook in excel 2011 and then copy and paste the data into it?
    Time-consuming I know but if you need it now or soon, might be the best way to go.

    - Simon

    If you have been helped, don't forget to use the Reputation system at the top right of their post.
    May 2011
    Nominated: March 2011 & April 2011

  3. #3

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Fort Worth, Texas
    27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, iPhone 6+, 3 iPods, El Capitan
    It may be too late... but did you have the option "always make a backup copy" selected in the 2011 Office preferences? If you did, the original worksheet will be located in your backup folder. If you didn't have that selected (you should) then you will have to use the suggestion that Buzzard offered.

    Note: Moved to correct forum.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2008 - Hyperlink error - Cannot open specified file
    By surfing_oz in forum OS X - Apps and Games
    Replies: 4
    Last Post: 11-08-2012, 02:02 AM
  2. Can't find .xltx file to delete / delete template excel 2011
    By sessions500 in forum OS X - Operating System
    Replies: 1
    Last Post: 05-07-2012, 07:30 PM
  3. Replies: 6
    Last Post: 03-02-2012, 02:34 PM
  4. Replies: 0
    Last Post: 09-20-2011, 02:08 PM
  5. Excel 2011 hyperlink "cannot open the specified file"
    By caligirl in forum OS X - Apps and Games
    Replies: 0
    Last Post: 06-08-2011, 09:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts