Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2015, 06:41 AM
orosos orosos is offline How to optimize an Excel file Windows 8 How to optimize an Excel file Office 2013
Novice
How to optimize an Excel file
 
Join Date: Apr 2015
Posts: 1
orosos is on a distinguished road
Default How to optimize an Excel file

I have a very big (42 MB) Excel file and I have deleted unnecessary worksheets, graphs, etc. but the size remains the same. How can I reduce the file size?
Reply With Quote
  #2  
Old 04-16-2015, 09:34 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to optimize an Excel file Windows 7 64bit How to optimize an Excel file Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,771
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
this being a well known problem there are lots of answers ( and possibilities) on the Net. Just Google around a bit

Good luck
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 04-16-2015, 01:27 PM
Jhnsnkth527 Jhnsnkth527 is offline How to optimize an Excel file Windows 7 64bit How to optimize an Excel file Office 2010 64bit
Novice
 
Join Date: Apr 2015
Location: Cincinnati
Posts: 7
Jhnsnkth527 is on a distinguished road
Default

As a quick attempt, I go to the last row of my data, select that row until the last row, right-click / delete those rows. Then I go to the last column of data, select that column until the last column, then right-click /delete those columns. Then I "SAVE AS" the file to a new name. This usually helps. SAVE AS might work all by itself.
Reply With Quote
Reply

Tags
file compression, size



Similar Threads
Thread Thread Starter Forum Replies Last Post
sending data from UserForm of existing excel file to a new excel file saltlakebuffalo Excel Programming 0 02-13-2014 10:55 PM
How to optimize an Excel file How to convert a text file to an Excel file with the data format automatically? mradmin Excel 6 10-16-2013 10:34 AM
How to optimize an Excel file how to copy some information from one excel file to another excel file tomlam Excel Programming 4 10-01-2013 03:06 PM
How to optimize an Excel file excel cannot open the file .xlsx because the file format or file extension is not val teddysika Excel 1 11-22-2012 06:06 AM
How to optimize an Excel file How to copy automatically data from Excel file to Word file? fuchsd Word 6 10-25-2011 05:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft