Help converting files to Excel 2007
Thread Starter
|
Postmaster
Joined: Aug 2004
Posts: 4,004
Likes: 1
From: North of Boston MA
Help converting files to Excel 2007
I recently purchased and installed Office 2007 to replace an earlier version.
I have a couple spreadsheets that have more than one page and when I open them up, all I can see is the first tab. The others aren't there. It also says Compatibilty Mode.
If I run the convert program it converts it to the new .xlsx file format and I completely lose the other tabs.
Is there any way to open the files in 2007 that will maintain the full spreadsheet? This is really starting to **** me off.
I've already downloaded all the Service Packs and the Compatibility Pack. All I need to do is convert my files without loosing any data.
Thanks.
I have a couple spreadsheets that have more than one page and when I open them up, all I can see is the first tab. The others aren't there. It also says Compatibilty Mode.
If I run the convert program it converts it to the new .xlsx file format and I completely lose the other tabs.
Is there any way to open the files in 2007 that will maintain the full spreadsheet? This is really starting to **** me off.
I've already downloaded all the Service Packs and the Compatibility Pack. All I need to do is convert my files without loosing any data.
Thanks.
Hotshot
Joined: Apr 2004
Posts: 13,589
Likes: 2
From: NW burbs of chicago
I haven't had to convert <2007 to the xlsx format, only the other way around and its worked flawlessly with the comp. pack.
I'm surprised that this isn't backwards compatible...
On second thought, My comp at work has office 03, my bro has 07. He can open everything i send just fine.
I wonder if you have to uninstall the previous office before installing 07.
Damn, i'm stumped
I'm surprised that this isn't backwards compatible...
On second thought, My comp at work has office 03, my bro has 07. He can open everything i send just fine.
I wonder if you have to uninstall the previous office before installing 07.
Damn, i'm stumped
Thread Starter
|
Postmaster
Joined: Aug 2004
Posts: 4,004
Likes: 1
From: North of Boston MA
Yeah, I'm pretty stumped too. I'm usually pretty good with this kind of stuff but this has me scratching my head. It seems like it should be a very easy process but for whatever reason, 2007 doesn't like the spreadsheets with more than one tab.
I use 2007 at my base and I have to convert from '07 to earlier versions all the time and have never had a problem except for some minor formatting changes. This is really annoying though.
I use 2007 at my base and I have to convert from '07 to earlier versions all the time and have never had a problem except for some minor formatting changes. This is really annoying though.
Moderator
Joined: Aug 2005
Posts: 164,377
Likes: 82
From: MA
It should convert them just fine, I am not sure what is causing it..
One thing I would do as a work around is open the old file then copy and paste into 2007..
As long as you only have a couple that would probably be quicker than fighting with it..
I am sure if it is a widespread problem MS will eventually issue a fix..
I will check some other sources to see if I can come up with anything else..
One thing I would do as a work around is open the old file then copy and paste into 2007..
As long as you only have a couple that would probably be quicker than fighting with it..
I am sure if it is a widespread problem MS will eventually issue a fix..
I will check some other sources to see if I can come up with anything else..
Thread Starter
|
Postmaster
Joined: Aug 2004
Posts: 4,004
Likes: 1
From: North of Boston MA
The problem with the cut and paste method is that I can't open the file with the old version which is now uninstalled. The new version will open the file in compatibility mode but with only the front tab. The rest of the workbook is gone. If I convert the file to 2007, it only converts the front tab.
Fortunately I have my files backed up on another machine and was able to recover the data. But, I have 2007 installed now on my primary home machine and it is driving me crazy that I can't use the new version.
I appreciate the help.
Fortunately I have my files backed up on another machine and was able to recover the data. But, I have 2007 installed now on my primary home machine and it is driving me crazy that I can't use the new version.
I appreciate the help.
Trending Topics
Cargo Master
Joined: Apr 2003
Posts: 3,476
Likes: 224
From: Frequently frozen MN
It should work ok, I move back and forth frequently. You might want to make a few copies and play around. Don't have any ideas because it works for me.
Compatibility mode just means that it knows that it's reading an earlier version.
You can 'save as' earlier versions (97-03 I think), which is what I do. I think that the xlsx files are xml, and I see no reason to go there.
Off topic - what do you think of the 'ribbon' interface ? I personally despise it, and have it turned off (as much as I can). I would have gotten 03 if it was still available.
Compatibility mode just means that it knows that it's reading an earlier version.
You can 'save as' earlier versions (97-03 I think), which is what I do. I think that the xlsx files are xml, and I see no reason to go there.
Off topic - what do you think of the 'ribbon' interface ? I personally despise it, and have it turned off (as much as I can). I would have gotten 03 if it was still available.
FTE Stories
Ford Trucks for Ford Truck Enthusiasts
Top 10 Most Expensive Ford Trucks Ever Sold on Bring a Trailer
Joe Kucinski
2027 Ford Super Duty Buyer's Guide (Every Model, Engine, & Package)
Brett Foote
Top 10 Ford Truck Tragedies
Joe Kucinski
AEV FXL Super Duty - the Super Duty Raptor Ford Doesn't Make
Brett Foote
Lobo Vs Lobo: Proof the F-150 Lobo Should Be Even Lower!
Michael S. Palmer
Ford's 2001 Explorer Sportsman Concept Looks For a New Home
Verdad Gallardo
10 Best Ford Truck Engines We Miss the Most!
Joe Kucinski
2026 Shelby F-150 Off-Road: Better Than a Raptor R?
Brett Foote
2027 Super Duty Carhartt Package First Look: 12 Things You NEED to Know!
Michael S. Palmer
Moderator
Joined: Aug 2005
Posts: 164,377
Likes: 82
From: MA
The problem with the cut and paste method is that I can't open the file with the old version which is now uninstalled. The new version will open the file in compatibility mode but with only the front tab. The rest of the workbook is gone. If I convert the file to 2007, it only converts the front tab.
Fortunately I have my files backed up on another machine and was able to recover the data. But, I have 2007 installed now on my primary home machine and it is driving me crazy that I can't use the new version.
I appreciate the help.
Fortunately I have my files backed up on another machine and was able to recover the data. But, I have 2007 installed now on my primary home machine and it is driving me crazy that I can't use the new version.
I appreciate the help.
What was the old version?? 2000, XP, 2003
What is the new version?? Student/Teacher, Standard, Professional, Ultimate, Small biz...
Another thing.... Are these just simple spreadsheets or do they contain macros or other special items??
Thread
Thread Starter
Forum
Replies
Last Post
ford2go
General NON-Automotive Conversation
5
Mar 6, 2014 10:08 PM