Microsoft Excel on Vista

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I purchased a laptop with Windows Vista. I then spent $160 for Microsoft
Office 2007 so that I could use it on Vista. Now that it is install,
registered and works fine on my computer, I cant send these files that I
create to ANYONE. Everyone I have emailed a workbook I have created in excel
says they cannot open it. Is this true? Now that I have spend all of this
money on Microsoft products, they made it so that I cannot actually use it
for what I need to?
I even tried to upload these excel files to GOOGLE DOCS & SPREADSHEETS, it
says NO!! we do not support this file type. Can anyone tell me what is
happening?
 
AngryVistaUser said:
I purchased a laptop with Windows Vista. I then spent $160 for Microsoft
Office 2007 so that I could use it on Vista. Now that it is install,
registered and works fine on my computer, I cant send these files that I
create to ANYONE. Everyone I have emailed a workbook I have created in excel
says they cannot open it. Is this true? Now that I have spend all of this
money on Microsoft products, they made it so that I cannot actually use it
for what I need to?
I even tried to upload these excel files to GOOGLE DOCS & SPREADSHEETS, it
says NO!! we do not support this file type. Can anyone tell me what is
happening?


This is not a Vista issue. The office 2007 file format is different from
previous versions. You need to go to "save as" in excel and select the
prior version format so others can open the file. Same for word etc I
think etc


Bill
 
Well, one new features of the Office 2007 along with "Ribbon" interface
is that it default saves in new and shiny OOXML format instead of old
propiretary format so older Office versions cant open it. You should
select Save As... Select Excel 97/2000/2003 format as format in the
dropdown box and save that way.

Csaba
 
I purchased a laptop with Windows Vista. I then spent $160 for Microsoft
Office 2007 so that I could use it on Vista. Now that it is install,
registered and works fine on my computer, I cant send these files that I
create to ANYONE. Everyone I have emailed a workbook I have created in
excel
says they cannot open it. Is this true? Now that I have spend all of this
money on Microsoft products, they made it so that I cannot actually use it
for what I need to?
I even tried to upload these excel files to GOOGLE DOCS & SPREADSHEETS, it
says NO!! we do not support this file type. Can anyone tell me what is
happening?

Office 2007 introduced new file formats. Excel now stores files by default
as .XLSX. If you want users of older Office versions to be able to read your
spreadsheets, store them in an older format with .XLS file ending (you can
choose from a list in the 'Store As' dialogue), or as .PDF files if your
recipients don't need to edit the spreadsheets.

Charlie42
 
Your are saving your documents in the default 2007. unique format. Use "save
as..." instead and use one of the more standard formats.
 
I purchased a laptop with Windows Vista. I then spent $160 for Microsoft
Office 2007 so that I could use it on Vista. Now that it is install,
registered and works fine on my computer, I cant send these files that I
create to ANYONE. Everyone I have emailed a workbook I have created in excel
says they cannot open it. Is this true? Now that I have spend all of this
money on Microsoft products, they made it so that I cannot actually use it
for what I need to?


Relax, and slow down. Your "problem" is easily solved.

By default, Office 2007 uses new file formats instead of the older
ones. In Excel, it now creates .xlsx files instead of the old .xls
files.

There are two easy solutions to your problem:

1. When you save your file before sending, use "Save as" instead of
"Send" and save it in the old format.

2. Alert the people you send files to of this situation, and ask them
to update their older copies of Office to be able to read the newer
files. See http://support.microsoft.com/kb/924074

Short term, solution 1 is easiest, but long term, they should adopt
solution 2.

By the way, this has absolutely *nothing* to do with Vista. It's
simply a an easily-fixed compatibility issue between Office 2007
(which doesn't have to run on Vista) and older versions of Office.
 
I purchased a laptop with Windows Vista. I then spent $160 for Microsoft
Office 2007 so that I could use it on Vista. Now that it is install,
registered and works fine on my computer, I cant send these files that I
create to ANYONE. Everyone I have emailed a workbook I have created in excel
says they cannot open it. Is this true? Now that I have spend all of this
money on Microsoft products, they made it so that I cannot actually use it
for what I need to?
I even tried to upload these excel files to GOOGLE DOCS & SPREADSHEETS, it
says NO!! we do not support this file type. Can anyone tell me what is
happening?

You'll need to use 'save as' and save as the older .xls file type. Quite
incidentally, if you had simply downloaded and installed OpenOffice.org
you'd have the same functionality and saved yourself $160.
 
andrewmoran said:
So I have been looking online for an hour now...is there anyway that
when I right click to "create new microsoft worksheet" that I can have
it default to create an XLS instead of an XLSX?

I don't have a copy of Excel7 in front of me here at the office, I use
it at home. ISTM that the decision between the older *.xls format and
Excel 7's *.xlsx format is made when you save the workbook, not when
you create it. You select the format you want in a dropdown in the
"Save" box.

Not having the program in front of me means that I can offer only
general advice. I'd look in the options settings and see whether you
can set the default "save" format. Failing that, maybe you can create
a macro that saves your workbook in *.xls format, then put a button on
the ribbon that you can use to invoke that.
I ask because I just lost a $685 invoice as I have to create them all
as XLSX when I create new, convert them to the readable xls file
extension, then delete the unusable XLSX file.

I guess I don't understand what you're doing. As I said before, you
make the xls/xlsx decision when you save the workbook. Maybe you have
a macro that creates and saves a workbook all at once?
 
Yes. Open Excel 2007
Click on the MS Pizza in the upper left and at the bottom of the menu, select "Excel Options"
in the Options window choose "save" in the left column.
Then change the "save files in this format" dialog box to "Excel 97-2003 (xls)".
This will automatically save all files in the XLS format.

A similar sequence in Word 2007 will let you save documents in the older DOC format
 
Back
Top