Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Why is Excel File so large?

Please could anybody assist me with the following: I have inherited an excel file that is excessive in size 12mb for what it is. Is there a way of finding our what is making it so large, eg something hiding etc? It does contain two logos but these are no different to any of the other files which are sitting at 2mb?
Any help gratefully received.


Post your answer or comment

comments powered by Disqus
My electronic timesheets are finally complete, and the only complaint I have about them is the file takes about 5-10 seconds to load. I assume this has to do with its size. The 2007 version (the version we will be using) is 7.34mb in size. Can anyone tell me why the file is so large? Is there a simple fix that does not affect my layout that will reduce the size or allow it to load more quickly? Thanks!

Final Template in Excel 2003 (18mb): http://www.jonvanwyk.com/FY2011TemplateExcel2003.xls

Final Template in Excel 2007 (7.34mb): http://www.jonvanwyk.com/FY2011TemplateExcel2007.xlsm

I have a file that is 90 mb, with almost the same content as another file
that is only 20 mb. WHY??? Is there a way to compact it?

I have taken out all formulas and filters. What else could be making it so
big?

It kills my memory to open the blasted thing, and slows me down in all other
applications as well.

Help me!
Thanks.
Julie

Why would a file that SHOULD be around 800k save as 4 Megs? and how the heck to I fix it without having to redo the whole darn thing?

The spreadsheet I have created for work currently consists of 9 worksheets and about 200 charts, with each chart having its own tab.

I use it to capture and calculate trend data that is then transferred automatically to the charts which, in turn, are linked to a small handful of PowerPoint Presentations and Word files that I use to publish the results. This happens monthly and quarterly, so automating the process has saved me far more headaches than the year it's taken me to create and "perfect" the current system would suggest.

The structure and function of the spreadsheet is as follows:

- Eight of the worksheets are used to capture monthly data. Each month, my direct reports and others send me the numbers and I simply plug them into the row for that month. These sheets also have a series of calculation tables that the charts use.

- The ninth worksheet has a very small handful of cells that the spreadsheet uses as variables for calculations. Chief among them is the "as of" month, which I use to generate the charts and trends "as of" the desired month. Since the historic data in the other eight worksheets goes back from two to three years, and the charts only trend back a year or two, this cell allows me to generate historic data at the flick of a switch. This switch (selecting the month) drives the calculation tables mentioned above, which means the charts all update as soon as I enter the new monthly data and enter the "as of" month. It's a beautiful thing, really.

The problem is, the file is now 40MB in size, and takes upwards of 5 MINUTES to load!

So what is it? The charts? The calculations?

At one point I saved a version that had all the charts removed. No improvement.

While the delay is far from crippling, it is a tad annoying. Was there a better way to have done what I did to avoid this, or is it simply time for me to ask my boss for a new computer?

Speaking of computers, I am on a Dell Latitude D620 laptop running an Intel Core 2 at 998 Mhz with 2 GB of RAM. Windows XP Pro Version 2000, SP2, and Excel 2003 SP3. My options for playing with software are limited since this is a work PC. Unless I can get a hardware update, my options are limited to the spreadsheet itself.

Thanks!

I have an Excel file that has four worksheets with minimal data in it - but
is 4.6 MB! There are no pictures in it, and the formatting is minimal
('bold'ed certain letters, used 'century gothic' font); there are no formulae.
It is a file with constantly changing data, which means that I have to
update it by copying, pasting and then deleting data (as opposed to 'cut and
paste' as this messes up the formatting).

Why is MS Excel renaming worksheets (truncating names)? Is there a fix for
this?
Why is Excel renaming worksheets? Is there a fix for this?
I am seeing something very strange with some Office-2003 Excel spreadsheets
I am trying to manipulate.
My spreadsheets contain many sheets (tabs), many with long names (e.g. 44
characters).
When I make copies of these spreadsheets the names of some of the sheets get
changed, i.e. truncated (e.g. down to 31 characters).
This is a problem for me because QTP is using the names of the sheets to
parse data.
Are you aware of any issues in Excel which might cause something like this?
The issue has only become apparent recently, spreadsheets created last year
did not suffer from this problem. Maybe it was introduced by a recent
service pack to Office-2003?
Exploration:
I installed OPENOFFICE 2.2 on my machine.
This a free counterpart of Microsoft office, available from
http://www.openoffice.org
When I manipulate spreadsheets in OpenOffice, the sheet name is preserved.
When I exit Excel after opening a spreadsheet saved in OpenOffice, Excel
asks me if I want to save it in the "new" Excel format .. Of course the
correct answer is "no".
However When I launch QTP using a spreadsheet saved in Openoffice, Excel
interrupts the QTP test and asks to resave the file in the new format. When
I click "no", the test then hangs. So I still do not have a solution to the
problem. Or does Microsoft have a fix for this?

My text file has 4 lines that I'd like to copy into Excel file. I want one line per cell in Excel, but somehow it breaks every text file line into multiple lines. It looks to me that Excel is breaking it every time it sees <p>. So instead of seeing just 4 Excel cells being filled up, I see over 50+

I don't want it to do that It didn't happen with one of my other text file so I am not sure what I did wrong this time…

I searched the forum and see most people want to split up the content, I don't want that in this case.

How should I fix this?

Please help. Thank you in advance.

I am attempting to download an Excel file from the web that has around 480
columns. When I try, I get message that states that it is too large and it
only displays one sheet with the standard 256 columns. How can I solve this
and get all of the information?

I have an Excel file that I use as a database with the dates of the
time when my company does the maintenance of our electronics tools (we
work in an industry that uses them a lot, we have around 200 in an
Excel file).

So the documents look as follows (the images are copied and edited in
paint, that's why they look kinda weird). They are next to each
other; I divided it here in order to fit it to word's format (it's
in Spanish, there's no need for you to understand what it says
anyway):

Go to www.caladeamerica.com.ar/1st file.jpg please and see it.

We do the maintenance of our equipment (each one with a code like
PT-01) and we change the date of the next maintenance. "Ultima"
means the last maintenance and "Proxima", the next one.
After we change these dates, we need to go to another file that is on
Word (that I could migrate to Excel if there's need to do it) and we
need to enter some info there. We do this manually now.
Let me show it for you. The document is larger than this, I'm just
posting the last section only, with the info we need to change:

Go to www.caladeamerica.com.ar/2do file.jpg and see it please.

So we enter the info on the next blank line about the maintenance that
was just done.

On the "Fecha" (date) we write the date of the current maintenance,
the one we just did.
On "descripción" if it was a "Verificación" or a
"Calibración" (two different kinds of maintenance, not all the
items need them both).
On result, if it was OK or not, I want to leave it blank on the
automated system anyway because we always need to write it in hand.
On "próxima - calib or verif" is the date of the next
"Verificación" or "Calibración".
That I need to be written automatically. If there's only one type of
test being done, I need the other one to get a "-" sign.
In "realizó" goes who did the work; we are going to write that by
hand.

So what I require is some automated way of inserting in the second file
(currently in Word, if it needs to be changed to Excel, that can be
done) the info that was written to the first one.
Let's say I do a "calibración" (one of the two possible types of
maintenance) and change the dates on the first file, I need it to be
reflected automatically on the second file, by inserting the info on
the next empty line.
The info I need to be inserted automatically is the one corresponding
to the "Fecha" (current date), description (saying if it was either
a verificacion or a calibracion) and the date of the next maintenance.
I used a color system to show you the info that needs to be connected
between both files. The system should identify if it was a verificacion
or calibracion automatically.

Thanks a lot for reading all this, I know this a big favour I'm
asking for and I'm greatly thankful.

Twice a month I update an Excel file to store our household finances and
bills when I pay bills. It has worked fine until about 2 months ago. When I
would close it, Excel would enter into Not Responding mode. I tried manually
saving the file before I close it and even while I am still working in it and
it still gets hosed. I can recover the file , thankfully, with the office
automatic recover feature, but it is very annoying.

Any ideas what is going on and what I can do to fix it?

Hi,

I origianlly posted this question under networking, but this may be a better
forum for my question.

Have a weird problem. We're on a Windows 2000 domain where the users' home
directory has been redirected using this syntax: fqdn.xxxdfs
rootsharename%username%. The DFS root server is a member file server that
holds the majority of the network shares (including the user profiles and
home folders). The DFS root is registered in our AD.

Here's the problem: Occasionally someone will try to open an Excel file on a
share via a DFS link and will get an error message stating that the
"fqdn.xxxdfs root" cannot be found. After a few minutes they can open the
file and this has only been reported to me 10 times or so out of 70 users
over a 60 day period, but I don't have an answer why this happens.

There is no problem with the Excel files in their home folder (also using
DFS) and when you check the DFS status of the folder they are having problems
with, it shows the status is OK. Additionally, any other type of file in that
folder can be opened with no problem--Word and text files open normally, but
I haven't tried Access files, as the problem usually fixes itself within 10
to 15 minutes. I can't find anything in the client or server logs that
indicate a problem.

The big mystery is why only Excel files are affected.

Any thoughts?

Byron

I have made excel workbook with 10 sheets. It is simple and has one sheet
with graph, and also 4 pictures of size 300Kb.

Why excel file is over 3100 Kb in size, or this is ok?

Thanks in advance

Is this due to the Undo savings? I'm wondering where I can check this since my excel files are > 100MB. Its all due to having so many formulas in the sheets.

if i can save 10% that's 10MB!!!

I have an Excel file that I use as a database with the dates of the
time when my company does the maintenance of our electronics tools (we
work in an industry that uses them a lot, we have around 200 in an
Excel file).

So the documents look as follows (the images are copied and edited in
paint, that's why they look kinda weird). They are next to each
other; I divided it here in order to fit it to word's format (it's
in Spanish, there's no need for you to understand what it says
anyway):

Go to www.caladeamerica.com.ar/1st file.jpg please and see it.

We do the maintenance of our equipment (each one with a code like
PT-01) and we change the date of the next maintenance. "Ultima"
means the last maintenance and "Proxima", the next one.
After we change these dates, we need to go to another file that is on
Word (that I could migrate to Excel if there's need to do it) and we
need to enter some info there. We do this manually now.
Let me show it for you. The document is larger than this, I'm just
posting the last section only, with the info we need to change:

Go to www.caladeamerica.com.ar/2do file.jpg and see it please.

So we enter the info on the next blank line about the maintenance that
was just done.

On the "Fecha" (date) we write the date of the current maintenance,
the one we just did.
On "descripci=F3n" if it was a "Verificaci=F3n" or a
"Calibraci=F3n" (two different kinds of maintenance, not all the
items need them both).
On result, if it was OK or not, I want to leave it blank on the
automated system anyway because we always need to write it in hand.
On "pr=F3xima - calib or verif" is the date of the next
"Verificaci=F3n" or "Calibraci=F3n".
That I need to be written automatically. If there's only one type of
test being done, I need the other one to get a "-" sign.
In "realiz=F3" goes who did the work; we are going to write that by
hand.

So what I require is some automated way of inserting in the second file
(currently in Word, if it needs to be changed to Excel, that can be
done) the info that was written to the first one.
Let's say I do a "calibraci=F3n" (one of the two possible types of
maintenance) and change the dates on the first file, I need it to be
reflected automatically on the second file, by inserting the info on
the next empty line.
The info I need to be inserted automatically is the one corresponding
to the "Fecha" (current date), description (saying if it was either
a verificacion or a calibracion) and the date of the next maintenance.
I used a color system to show you the info that needs to be connected
between both files. The system should identify if it was a verificacion
or calibracion automatically.

Thanks a lot for reading all this, I know this a big favour I'm
asking for and I'm greatly thankful.

I am attempting to download an Excel file from the web that has around 480
columns. When I try, I get message that states that it is too large and it
only displays one sheet with the standard 256 columns. How can I solve this
and get all of the information?

I have made excel workbook with 10 sheets. It is simple and has one sheet
with graph, and also 4 pictures of size 300Kb.

Why excel file is over 3100 Kb in size?

Thanks in advance

Hi all

I have a spreadsheet that contains vb code/macro's that "locks up" my pc as Excel takes up 98-100% CPU usage. I've sent the file to others and the same thing occurs. It's not consistent though - sometimes it happens and other times it's fine.

I didn't create the spreadsheet from scratch myself - I've taken someone else work and expanded on it, so I don't know if there are any 'hidden' items that is causing this to occur.

I think the reason is that excel is continually recalculating, so I was hoping to get some ideas of what I could check? The spreadsheet is on auto-calculate (ie. default) and I don't have any user-defined functions (that I can find anyway).

Any help will be gratefully received as I am supposed to email this file to around 25 people tomorrow and I don't want to send it when it locks up.

I am a business school student. Recently we made an questionair by excel. We put it onto the website of our sponser chamber of commerce. Enterpreneurs will open it from this website and fill in, and will get result by submiting automatically.
We made several macros in this excel file.
Now the problem is that some of our enterpreneurs refuse to open it for the reason that they fear opening an excel file with macros enable will bring viruses into their computers. You see, when you set your excel in medium level of security, when you open an file with macros involved, the computer will always warn you that enabling macros may bring in viruses.
If enterpreneurs refuse to open it from their computers, our work will be meaningless.
I think if the macros are made by yourself, and the file you need to open is on the website like Chamber of Commerce, there should no possiblity of getting viruses. Am I right? How should I convince them? Or maybe I am wrong, it is still dangerous? Great thanks for your help.

I know this is essentially an Excel question, but thought it would qualifyas Excel is 'part' of the question....

I am writing some procedure notes in Word and want to include a hyperlink to the required Excel files so the user can click on the hyperlink and the file will open in Excel.

I have been trying to do this as per this link http://www.shaunakelly.com/word/Exce...nks/index.html but just cannot get it to work.

Rather then my location showing a drive name and then colon, e.g. 'S:' when I copy the excel file location details using 'File', 'Properties' it shows 'nat-fap-xxx-s01' so I am not sure how to start the file location details.

Thanks

I am building an application with an icon that launches an excel file
when clicked. Is there any way I can open the file directly to a
specified worksheet? The names of the worksheet are fixed and so is the
file, so I am guessing adding some parameter after the filename should
do the trick. Any help will be appreciated.

Regards

Sid

--
skiddyrow
------------------------------------------------------------------------
skiddyrow's Profile: http://www.excelforum.com/member.php...o&userid=23965
View this thread: http://www.excelforum.com/showthread...hreadid=386335

I emailed an Excel file to a colleague. It was sent as an attachment in
Thunderbird. The recipient - who uses Outlook - saved the spreadsheet to disk.
Now if she tries to launch the file (either from Explorer or from within Excel
itself), it actually opens up inside Outlook and starts to create an email
message. This only occurs if Outlook is already active. It also only occurs with
some of the spreadsheets that I sent her.

Ideas?

I am trying to create a hyperlink from one excel file (so you just have to
click on it) and it will open up the referenced excel file, but more
specifically will open the file to the certain sheet you want it to open to.

Is this possible, and if so what is the code or shortcut to get this to work?

Thanks,

Hey guy's

I've been searching the web for quite some time now, but i cant find it.

First off:
My skills: Limited ( first time using vba,, but search the web for hours, so i know some basic stuff what i've read)
My programs: Office 2010
My question:

I have an map full with .doc files and want to convert them to excel files.

The word file has an table in it with data, This data is from machine specs, and i want to import them in to an excel database.
I thought the best thing is save / export the word table to an excel file.
And later on make an (master) excel file and link the seperate files to this master file.

I've got an working macro to import table dat from word in to an excel spreadsheet (found it on the web)
But it is limited to one file ( i've got 200/300 files so it would be easy i've vba can do it for me )

Code:
New Text Document (6).txt

I want to automate the proces and let it save the workbook automaticly
And this code only get cells 3,2 and 4,2
I want many more ranges and data cells, these i've already got sorted in another excel file so i can copy them real quick
But it needs an additional bit that overrules the empty cells ( i've pasted my ranges and cells in the macro ) and that works, but i get an error on every empty cell ( i dont have that basic knowledge )

I think you guy's can help me!
So please do so.

Edit:
To make the macro working i've changed Dim wdDoc As Word.Document
the Word.Document to Object.

Hi,

I'm having some trouble accessing the Excel "solver" tool on new worksheets
I create within a default .xls file.

Are there possible memory limits on a file size that prevent "solver" from
running? Is "solver" on the Office XP version explicitly limited to 4 or
less
sheets? It's a shame I have to let this spreadsheet die than continue.
Can anyone suggest a way to make "solver" accessible from any worksheet
within my Excel file?

Thanks.


No luck finding an answer? You could always try Google.