New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Excel 2008 and 2011 file


Post Reply New Thread Subscribe

 
Thread Tools
seetim

 
Member Since: Dec 12, 2010
Posts: 11
seetim is on a distinguished road

seetim is offline
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
QUOTE Thanks
Buzzard2010

 
Buzzard2010's Avatar
 
Member Since: Oct 22, 2010
Location: Bretforton, Worcestershire
Posts: 2,573
Buzzard2010 is just really niceBuzzard2010 is just really niceBuzzard2010 is just really niceBuzzard2010 is just really niceBuzzard2010 is just really nice
Mac Specs: MacBook Pro 15" 2014, 2.2GHz i7, 16GB RAM, 250GB SSD, OSX 10.9.5 - iPhone 5s 16gb

Buzzard2010 is offline
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
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 40,056
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is online now
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« Business App for receipts? | Flash on my website works in Safari, but not Firefox »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Text alignment problems in MS Office Word 2011 (and 2008) immanence OS X - Apps and Games 2 10-19-2011 02:56 PM
Installed Office, curious about folder in apps grid darga19 Switcher Hangout 16 01-16-2011 01:29 PM
Office 2011 for Mac requires activation PKGuy323 OS X - Apps and Games 18 10-25-2010 06:33 PM
Excel or Mac Garoolgan OS X - Operating System 4 04-26-2008 12:07 PM

All times are GMT -4. The time now is 08:00 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?