×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

File Size in Excel

File Size in Excel

File Size in Excel

(OP)
Anybody know of a way of compressing files in Excel like you can in Access? I need to make sure a spreadsheet can fit onto a floppy disk but without using any zipping methods. The people who are using the spreadsheet work offshore and need to be able to leave a copy of the spreadsheet on the rig.

RE: File Size in Excel

The only thing that I know of is that saving it as a text file, or in a delimited format cuts the size a good deal. (I experimented with a 16k Excel format sheet and dropped it to 1k). Goo Luck, Kimi

RE: File Size in Excel

Have you tried everything (remove unnecessary formattings, sheets, sheet headers)? Use Excel4 saving format if possible. You can get the minimum size by using the KimiSue's tip. Try load that text file back to Excel and see how much Excel 'fatted' the file. Especially Excel5 puts easily extra weight if you apply some font or sheet formattings.

Again, good luck
Al

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close