Excel Tips - Why Is My Excel File So Big ?

Hi, everyone,

Please let me know any tips to reduce the size of an excel file. I'm have a file with several modules which generates an end report. I wanted to reduce the size of the file I remove the modules from the end report though...Is there anything else that I can do apart from this to reduce its size

Hi guys,

I am about to undertake a fairly large spreadsheet development project. One of the key requirements is that the size of the spreadsheet be kept to below 4mb, preferrably below 1mb. This is due to an unavoidable restriction.

Although the spreadsheet will not have large volumes of data, it will contain approximately 30 sheets. There are no graphics embedded in the sheet. I imagine there will be a reasonable amount of VBA and/or forumulas in the sheet. Each sheet will basically be a data-entry form with a number of formulas. No sheet will have more than 100 rows.

Without knowing the full details of the spreadsheet, it is difficult for you to give a definite answer as to the size of the sheet, so I am simply looking for some helpful tips in keeping the size down.

Do formulas take up more space than VBA code? When I format cells, should I format the entire row, or just the range? Do features like sheet and cell protection take up a lot of space?

Any other tips or suggestions?

What is the easy way to create forms in different sheets.......

In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......

Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards

J-O

Hy guys,

I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help

Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.

-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?

Thank you.

Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub

Hey,

Has anybody noticed that all the help sections of the date/time help in excel tips is missing any information that's normally there?

just thought I would mention it.


oliver.

I was trying to create a template for my colleauges and here is what I want to achieve.

Problem 1:
We have 5 admin staff member,
Melissa, Jo, Jenny and Bella and Cindy. And on the Excel spreadsheet, I have a column of Processed by (which will be either the names of these 5 ladies). How do I build in this names so that nobody will use other names rather like Mel or Joanne or Jen or Candy (wrong spelling anyway) in that excel spreadsheet? (I was manually typing those names, select the names, used data-data validation-list)- didn't work very well because I don't want the names to show up when they first started off that spreadsheet.

Problem 2:
I have plugged in some formulas in my excel spreadsheet. I want my formulas to remain there, but I don't want any figures such as 0, #N/A s to appear until figures in the appropriate columns are filled in. How do I make the result/formula invisible?

Resolving will help me solve the initial problem and keep me going on my template. Your help is greatly appreciated.

Good afternoon/morning/evening.

Many thanks to all of you who have requested and suggested tutorials to
be posted on my blog http://teachr.blogspot.com over the past couple of
days. I'm currently working on more new content for the blog and
really appreciate your input.

If you have any more ideas please please keep them coming, as I want as
many tutorials, tips and hints for excel as I can get to keep my blog
interesting an useful to those who visit.

Once again, if you have any requests, ideas or tutorials of your own
for the site, please email me at mattyboy150279@gmail.com and let me
know. Similary if you want an update on new tutorials posted please
send me a similar email with the heading SUBSCRIBE, and I will update
you whenever there is new content.

Thanks again, and keep 'em coming!

Kindest Regards,
Matt
http://teachr.blogspot.com - For Excel Tips and Tutorials

Hi,
More often than not the various solutions posted for manipulating charts in Excel 2007 with VBA are issue specific, which may be adapted by other users to suit their needs.
This is great, but often means trolling a large number of threads and posts before you find something you can use/adapt.

Given that chart methods are very difficult to track down and the VBA chart object model in XL07 isn't terribly helpful, and to possibly help users with basic manipulation I've started this thread in the hope that others will contribute snippets of code for making changes to charts in XL07 using VBA.

To start the code below can be used to make the chart border invisible for every chart in the active sheet.

Code:

Sub Remove_Chart_Border()
' Use this to make the border on each chart in the active sheet invisible
'
' Get the number of charts in the active sheet
NumberOfChartsInActiveSheet = ActiveSheet.ChartObjects.Count
'
'Create a For/Next loop to cycle through each chart in the active sheet
For ChartLoop = 1 To NumberOfChartsInActiveSheet
'
'activate the next chart in the loop
ActiveSheet.ChartObjects(ChartLoop).Activate
' Do something with the active chart
With ActiveChart
' In this case the "do something" is set the line of the border of the Chart Area to invisible (visible = false)
    .ChartArea.Format.Line.Visible = msoFalse
End With
'
'move on to next chart in the loop
Next
'
'
End Sub

My knowledge of manipulating charts with VBA is very limited, so I'm hoping other (likely more experienced) forum members will see this as a good idea and tag on.