Making File Smaller With Faster Load Times

Mar 4, 2014

Is there a way to reduce a file's size to make it smaller with faster load times? I have a file that has ballooned in size due to the number of formulas and images I have installed.

Sometimes the file shuts down on it's own and make's my computer really slow.

View 6 Replies


ADVERTISEMENT

Load Multiple CSV Files In A Spreadsheet Faster

Jan 5, 2010

In my spreadsheet I load 26 CSV files. Each CSV file has 3 columns and 7 rows. It uses the connection query in Excel. It is only relatively slow to refresh the data. To refresh the data, I can press the refresh data button in Excel.

But in practice I use this code every 5 seconds:

View 9 Replies View Related

Making Spreadsheet Smaller?

Mar 28, 2014

I built what I can only describe as a fantastic spreadsheet. It wasn't until after that I realized it is 123 MB in size, but even for the complexities within it, it still feels like that is quite large.

I can't share the file due to proprietary reasons, but any general tips as to things I can do to make it smaller (and therefore faster to run).

I tried saving it as a binary spreadsheet and that dropped it to about 80 MB, but I don't really know what that does and if it will impact the sheet performance in any way.

View 2 Replies View Related

Making A Spreadsheet Smaller On Opening

May 16, 2007

I have a 30 in monitor (I know I'm lucky!) but when I open a new spreadsheet it opens all the way across the screen 100 columns and 100 rows. How can I change the size when it opens?

View 9 Replies View Related

Making A Checkbox Load A Value Of Yes Or No

May 19, 2009

I have a checkbox with a userform. I can get it so that if I enable it and add data then it correctly shows as "Yes" or "No" within excel. However if I open the data using offset the checkbox is greyed out with neither Yes or No. Is there a way to make the checkbox allow and show a value of Yes/No?

View 7 Replies View Related

File Size Made Smaller

Apr 20, 2006

Is there a way of eliminating un-used rows & columns to bring your file size down.

I already know about eliminating unnecessary pages, and I've cleaned up defunct modules, etc., and anything else that's just clutter.

The Row & Column thing would be a big help.

View 7 Replies View Related

Split Excel File Into 5 Smaller Files

Dec 17, 2013

I have an excel spreadsheet that has over 10 thousand rows and is 40+ Mb in size. It is giving me timeout errors when trying to import it into Joomla 2.5. Therefore, I need a way that I can easily split the file into 5 smaller files. Here are the column headers: titlemetadescmetakeyaliascategory_pathstateintrotextaccess

I tried doing it manually but is said the cell sizes were different...

View 3 Replies View Related

Split Large File Into Multiple Smaller Files

Dec 12, 2009

On this forum, a script is provided to break a large Excel file into smaller 500-line files:

Split Worksheet Into Multiple Files By Every Nth Row

I copied the code and pasted it into the VBA editor in Excel 2007, but when I run the macro, it generates an error message:
Runtime error 91: Object variable or With block variable not set.

The line the debugger identifies as the one with the error is this one:
For lLoop = 1 To rLastCell.Row Step 500

Here is the full code from the previous thread: ...

View 9 Replies View Related

Load The XML File In 2007

Apr 27, 2009

I'm trying to load the following XML file in Excel 2007 (from Excel 2007 VBA Programmmer's Reference) and get the error "Strict Parse Error" when I do so.

View 3 Replies View Related

Execute AutoCad & Load File

Jun 18, 2008

how to execute a program by clicking a button I created inside an spreadsheet and also how to load a file into the program I open.

View 6 Replies View Related

Opens But Doesn't Load The File I Just Clicked On?

Oct 14, 2008

if i double click to open a xls file (excel not open) then excel opens but doesn't load the file i just clicked on?

View 9 Replies View Related

Load Listbox Specific File Types

Jan 7, 2007

I found this code by Will Riley


Private Sub UserForm_Initialize()
Dim fileList() As String
Dim fName As String
Dim fPath As String
Dim I As Integer
'define the directory to be searched for files
fPath = "C:Will"

Would like to change

fName = Dir(fPath & "*.xls")

to load graphic files, .jpg, .jpeg, .bmp, .gif, instead of excel files.

It works if changed to .jpg only but as soon as I try multiple file types it does not work.

View 9 Replies View Related

Data Load (search And Load .csv Files Automatically In Workbook)

Dec 16, 2002

I need to do a macro that will open a search window, the user would select a folder and it will search for a .csv file within it. Then after locating the file, it would automatically load it into a specific sheet in the workbook.

View 9 Replies View Related

Macro To Load All Files Within A Folder To New Tabs With File Name As Sheet Name

Nov 26, 2009

I wish for a macro to look in to a directory which remains constant, but then looks within a folder which is specified via a cell value in order to load a specific sheet from each file in to the workbook I am currently using. I wish for the loading to be done without having to open the workbooks manually, so something which opens them copies the data from the sheet specified and then closes.

This data is then to be pasted in to a new sheets within my workbook which are named after the file names that it pulls the "dump" sheet from.

As a side note, I will be using these sheets to produce calculations hopefully automatically as soon as they are loaded. They all have the same "shape" but contain differing data. Will it be easier in the long run for me to use this method of pasting data to new sheets named as their file names assuming there will be around 25 "dump" sheets needing to be loaded or would i be better having them paste all to one sheet just underneath each other with a couple of rows separating them?

View 8 Replies View Related

Split Text File Into Smaller Text Files

Mar 15, 2005

I'm trying to take a large text file and break into smaller text size files. I want to open the data file, and parse into 5000 line smaller files.

Here is what I have based off of some MS KB
Sub LargeFileImport()

'Dimension Variables
Dim ResultStr As String
Dim FileName As String
Dim FileNum As Integer
Dim Counter As Double
Dim CounterMax As Double
Dim sPath As String
Dim FileCounter As Double
'Output File

View 9 Replies View Related

Copying .xls File Numerous Times And Rename Each File From .xls Spread Sheet

Nov 24, 2009

I have an excel template that needs to be copied multiple times and each sheet needs be named according to a list in an excel spread sheet. I also have a formula in the template that needs the value copied instead of the formula.

I got this script from an site and tried it. It runs but I don't see any spread sheets.

strComputer = "."
Set objWMIService = GetObject ("winmgmts:\" & strComputer & "
ootcimv2")

View 9 Replies View Related

Making Labels From Excel File?

Sep 9, 2012

making labels from excel file

View 1 Replies View Related

Making List Of Excel File Authors?

Sep 18, 2013

I have a bunch of excel files in a folder, and I want to make an excel spreadsheet that makes a list of them all. This drive is a shared drive and their are different authors for files. I have already made the list, with the file name, date modified, date created, etc. However, I am having trouble importing the list of the authors for the files. Is there a way to automatically import a list of excel files in an excel, with an "authors" column? I can't do it manually, for their are hundreds of excel files.

View 1 Replies View Related

Making Text To Columns Permanent In A File

Sep 7, 2007

I have some text that I am having to analyze which comes out of our computer looking like this:

N/0/N/Y/N/N/N/N/N/N/N/N/N/N/N/N/N

I use the text to columns function and headers above it to translate what each field is.

As I'm doing my testing if I do this once, I can keep the file open and any time I paste a similar entry in it takes care of the formatting.

But, is there way to make the file do that permanently? I want to let the other testers use it without making them have to go through the steps of clicking on the delimiter, etc.

View 9 Replies View Related

File / Workbook Created By Macro Is Making It Heavier?

Jul 4, 2014

I am creating 4 Sheets from a Main Sheet by Filtering Data based on different values in a fixed column, then the Filtered Rows are automatically pasted in the respective sheets.
Then these 4 Sheets are creating another file.

The same thing done manually by Grouping the 4 SHeets and then Move Copy into a New workbook also makes the file heavier.

Everything works fine however though the data is not much the file is very heavy, so what do i do to make it of appropriate size ?

View 1 Replies View Related

Counting The Number Times A File Is Opened

Oct 14, 2009

I have a workbook setup as Read only for reporting purposes. I would like to capture the number of times and if possible, the users that are opening the file....is there a way?

View 9 Replies View Related

Making Excel File Accessible For Few Users But One User Should Not See Other User Entries

Jul 11, 2012

I have an excel file with multiple sheets. I want my HR team to update that file, but one user shouldnt see the entries of other users. I want to make a consolidated file out of three files. This excel template is for salary input.

View 3 Replies View Related

Faster Than For Each

Apr 4, 2007

I'm using the following code to populate the columns next to the dynamic named range dataforgraph (varies in length). It works, but the problem is that it takes ages. Is there a more efficient way of doing it. It is important that it only populates the cells next to the varying dataforgraph. The avg1 and stadev1 are the same for each entry (thus constants)

For Each c In Sheet3.Range("dataforgraph")
c.Offset(0, 1) = Sheet3.Range("avg1")
c.Offset(0, 2) = Sheet3.Range("avg1") + Sheet3.Range("stadev1")
c.Offset(0, 3) = Sheet3.Range("avg1") - Sheet3.Range("stadev1")
c.Offset(0, 4) = Sheet3.Range("avg1") + 2 * Sheet3.Range("stadev1")
c.Offset(0, 5) = Sheet3.Range("avg1") - 2 * Sheet3.Range("stadev1")
Next c

View 3 Replies View Related

Reduce Number Of Times Opening And Closing Blank Source File

Jul 9, 2012

I have code in VBA that takes a source Excel file and parses it to multiple re-formatted worksheets. Each formatted worksheet is different depending on a variable in the source. There are n of each type of data (1:n Water Sources, 1:n Water Treatment, 1:n Water Storage). Each item needs a copy of a blank re-formatted worksheet appended to the end of the existing data-type worksheet. For example: Water Source #2 is appended to the bottom of Water Source #1 on the same worksheet.

Currently, I am opening the blank re-formatted workbook each time an additional variable of same type is found in the source file. Meaning, if there are 8 Water Sources, I am opening and closing the blank re-formatted workbook 7 times to copy a blank Water Source to the bottom of the Water Source worksheet and then populate the data. AND if there are 3 Water Treatment, I would open and close the blank formatted workbook 2 more times to copy a blank Water Treatment to the bottom of the Water Treatment worksheet. The same goes for Water Treatment.

Obviously, a huge waste of resources and performance. I would rather open the blank re-formatted workbook once (first time an additional worksheet is needed), use the worksheets as needed, and close it at the end.

Attached is my current, working code of the above.

How should I re-write it to check if the blank workbook is already open use it, if not open it?

Code:
Sub Add_Facility(ByVal Worksheet_Name, Copy_Range, Max_Limit)
Dim Last_Row As Integer
Dim Source_Range As Range
Dim Dest_Range As Range
Dim wkb As Workbook

Set wkb = ActiveWorkbook

[Code] ........

View 5 Replies View Related

Embedded Bigger Than Smaller Than-IF

Jul 13, 2009

The jist of the problem is that employees are paid their normal wage up untill 37.5 hours of work. From 37.5 to 40 hours of work they are paid 1.5 times their wage. Any hours over 40 are paid at 2 times the regular wage.

So i need a formula that can work out their total pay. Im not sure what i could put in a dummy document to help you since it would just be one cell for their hourly wage, one for their hours worked and then one for the calculation. so you can reference any cell as an example and assume £6 as hourly rate

View 3 Replies View Related

Greater Than, Smaller Than Formula

Dec 21, 2005

When grading children's test scores I want to apply letters and numerals to particular ranges eg between 21 and 25=3c 26and 30=3b. Please help with a formula.

View 14 Replies View Related

Splitting Big Value Into Smaller Values

Apr 22, 2014

I have some spreadsheets containing substantial rows of data, basically 3 columns as this:

Sample
Start
End
Difference (End-Start)

A
1500
1600
100

[Code] ......

And what i want to obtain is different rows of data such as every row has the same difference (20 in this case, without changing the first column), like the following (never mind the colors, they are only to make my point clear):

Sample
Start
End
Difference (End-Start)

A
1500
1520
20

[Code] ........

We can also think about splitting only one certain number into 20's, like in the case of samples B and C above, because I have already split the data into separate sheets based on their "difference" value, using link:

Copy to new worksheets. Do you think it is doable?

View 2 Replies View Related

Calculates Faster Than IF

Aug 21, 2009

I have an entire row of if statements that basically check other sheets if a number occurs. If it does then it will display "Pending Approval" ,"Open", or "Closed" depending on which sheet the # appears on .. Just wandering if their was a better formula for this..

View 7 Replies View Related

Faster (non-loop?) Way Of Doing This

Jan 22, 2009

Is there a faster (maybe a non-loop) way of doing this?

Private Sub Worksheet_Activate()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

Dim Test1 As Single
Dim Test2 As Single
Dim Test3 As Single

With Sheet2

For Test1 = 33 To 52
If .Range("J" & Test1).Value = "End" Then
.Rows(Test1).Hidden = True
Else: .Rows(Test1).Hidden = False
End If
Next Test1

This causes a bit of a delay (7 seconds or so) when switching to the sheet, which is causing the user to think that excel has locked up.

View 9 Replies View Related

Determine If Any Value In A Range Is Greater/Smaller Than Another Value

Jun 20, 2008

If any cells in (Specified Range) are greater then (Number) then say true else say false. And how I would write it.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved