Trouble saving Vista Excel files as an earlier version

  • Thread starter Thread starter Wild Appetite & Urban Thirst
  • Start date Start date
W

Wild Appetite & Urban Thirst

I am the only one in the company who has Vista on their PC.
When I create an excel file and save it as an earlier version it creates a
really huge file which is then too big to send by email and it jams my email
programme. (eg: normal file size is 100KB but when I 'save as' it creates a
file of 8000KB)
If I dont save as an earlier version, no-one else can open them.
I am running Microsoft Office Excel 2007.
I want to save the files as Excel 97-2003 worksheets.

Any help on this would be greatly appreciated as I am at a loss even after
searching for a solution on various websites.

Thanks, Tracey :-)
 
"Wild Appetite & Urban Thirst"
I am the only one in the company who has Vista on their PC.
When I create an excel file and save it as an earlier version it creates a
really huge file which is then too big to send by email and it jams my
email
programme. (eg: normal file size is 100KB but when I 'save as' it creates
a
file of 8000KB)
If I dont save as an earlier version, no-one else can open them.
I am running Microsoft Office Excel 2007.
I want to save the files as Excel 97-2003 worksheets.

Any help on this would be greatly appreciated as I am at a loss even after
searching for a solution on various websites.
Click to expand...

Maybe creating a ZIP file and compress it? What are you on dial-up that it
takes too long to send it?
 
Wild said:
I am the only one in the company who has Vista on their PC.
When I create an excel file and save it as an earlier version it creates a
really huge file which is then too big to send by email and it jams my email
programme. (eg: normal file size is 100KB but when I 'save as' it creates a
file of 8000KB)
If I dont save as an earlier version, no-one else can open them.
I am running Microsoft Office Excel 2007.
I want to save the files as Excel 97-2003 worksheets.

Any help on this would be greatly appreciated as I am at a loss even after
searching for a solution on various websites.

Thanks, Tracey :-)
Click to expand...
Have them install the compatibility pack.

http://office.microsoft.com/en-us/products/HA101686761033.aspx

Frank
 
OK, If I install the compatibility pack on my PC, it will make the file size
smaller?

I cannot install on other PC's as most are out of the office with laptops,
etc and it also affects emailing info to our customers.

If I create a zip file it takes the 8000 kb file down to 716 kb
If I save a a PDF file it takes it back to the normal size of file but then
they cannot edit the excel spreadsheets.
 
Wild said:
I am the only one in the company who has Vista on their PC.
When I create an excel file and save it as an earlier version it
creates a really huge file which is then too big to send by email and
it jams my email programme. (eg: normal file size is 100KB but when I
'save as' it creates a file of 8000KB)
If I dont save as an earlier version, no-one else can open them.
I am running Microsoft Office Excel 2007.
I want to save the files as Excel 97-2003 worksheets.

Any help on this would be greatly appreciated as I am at a loss even
after searching for a solution on various websites.

Thanks, Tracey :-)
Click to expand...

Microsoft Office (Excel) is NOT part of Vista so this is not the best place
to get help, try posting in microsoft.public.excel or
microsoft.public.excel.misc newsgroups, thats where the Excel boffins hide
out.
 
Wild said:
OK, If I install the compatibility pack on my PC, it will make the file size
smaller?
Click to expand...

Of course not. You already have Office '07 installed.
I cannot install on other PC's as most are out of the office with laptops,
etc and it also affects emailing info to our customers.
Click to expand...

Why can't you email the link to them and have them install the pack?
If I create a zip file it takes the 8000 kb file down to 716 kb
If I save a a PDF file it takes it back to the normal size of file but then
they cannot edit the excel spreadsheets.
Click to expand...

Simple answer, have all of your targeted recipients install the
compatibility pack.
Frank

btw, this is the Vista ng. You should actually be posting your excel
question to the excel ng, just FYI.
 
"Wild Appetite & Urban Thirst"
No, not on dial up, am on broadband
So I 'save as' Zip file?
Click to expand...

http://en.wikipedia.org/wiki/ZIP_(file_format)

http://office.microsoft.com/en-us/help/HA011276901033.aspx
<http://www.maximumpcguides.com/compress-and-uncompress-a-folder-or-file-in-windows-vista/>

Windows XP can zip and unzip a folder or file, for your recipients that have
Windows XP.

WinRAR is free.

http://www.download.com/WinRAR/3000-2250_4-10007677.html

You can use Winzip for free for something like 60 times before you have to
buy it.
http://www.winzip.com/downwz.htm

In any case, you take your excel file and you zip it up and send it. The
recipient will have to use a zip tool like the ones above to unzip the file.

The smaller the total file size is the faster it will be sent via email.
 
Wild Appetite & Urban Thirst
OK, If I install the compatibility pack on my PC, it will make the file size
smaller?
Click to expand...

The compatibility pack goes on their computers. Then their older
version of Excel can read the Excel 2007 *.xlsx format.
I cannot install on other PC's as most are out of the office with laptops,
etc and it also affects emailing info to our customers.
Click to expand...

The pack is a free download from Microsoft:
http://www.microsoft.com/downloads/...70-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en
If I create a zip file it takes the 8000 kb file down to 716 kb
If I save a a PDF file it takes it back to the normal size of file but then
they cannot edit the excel spreadsheets.
Click to expand...

So a zip file might be your best bet. WinXP can open zips without any
third-party help.
 
I've seen this with several of my customers, but it's not a Vista thing as far as I can tell. Don't know what causes it but with one case I simply deleted one of the unused sheet tabs. This brought the file size back to normal.
The other case I had to copy the data, paste it to another new workbook, then save. The new book was the correct file size.
In the two cases I've found, they were using Office 2007 and others in the company had the compatibility back for older versions.
 
Back
Top