Hello Nanjing

Switch to desktop Register Login

Welcome, Guest
Username: Password: Remember me

TOPIC: How to resize an Excel file?

How to resize an Excel file? 4 years 1 month ago #19786

  • NinjaAnna
  • NinjaAnna's Avatar
  • OFFLINE
  • Junior member
  • Posts: 29
  • Thank you received: 2
  • Karma: 5
Hello All

I have got a problem with an excel file. It contains 1679 sheets of data and it should be around 500Kb large.But this file is 13Mb large.It takes a few minutes before it has saved and opened.I need to send out this file but now I couldn't. I have deleted more than 10,000 sheets but this won't reduce the size. I also tried to "select all" and "copy" it to another blank Excel ,however it wouldn't let me execute.

Attached is the screen capture of the Excel file, for your reference.

Attachment ScreenShot002.jpg not found




Does anybody there know what this problem would be and how to solve it.
Thanks a lot.
The administrator has disabled public write access.

Re: How to resize an Excel file? 4 years 1 month ago #19788

  • kaidokido
  • kaidokido's Avatar
  • OFFLINE
  • Junior member
  • Posts: 26
  • Thank you received: 1
  • Karma: 0
My solution:

check it out whether there are so many formulas. if so, and the formulas are not so important, convert them into value.
otherwise, remain the formulas, try some sort of file-compressing software,such as 7-zip(free software) to pack your excel file.

wish that could help.
The administrator has disabled public write access.
The following user(s) said Thank You: NinjaAnna

Re: How to resize an Excel file? 4 years 1 month ago #19789

  • NinjaAnna
  • NinjaAnna's Avatar
  • OFFLINE
  • Junior member
  • Posts: 29
  • Thank you received: 2
  • Karma: 5
Thank you for your help.
I have tried both before but seems these are not the right solutions:(
I have also saved the file as other formats ,however, still won't change anything.

This really bothers me a lot because I really need to send this file to my colleagues in Sweden.
The administrator has disabled public write access.

Re: How to resize an Excel file? 4 years 1 month ago #19790

  • kaidokido
  • kaidokido's Avatar
  • OFFLINE
  • Junior member
  • Posts: 26
  • Thank you received: 1
  • Karma: 0
we are both native...

Would you mind talking me by QQ mail?( i couldn't access the IM, but can visit the web mail.)

Email Add:
li.pengyun#qq.com (change "#" to "@" ,pls)
The administrator has disabled public write access.
Moderators: mach5
Time to create page: 0.147 seconds
Powered by Kunena Forum  Protected by R Antispam

Copyright 2015, SinoConnexion Ltd. No part of this website (images or text) may be reproduced without prior permission.

Top Desktop version