file size

Hi all, I have a file of 7 mb having 100 columns and unlimited rows (user defined- approx 500). At all these cells in that area, I refresh (copy/paste) the same formula for all cells, read as...

I have a program that uses macros to auto populate data within a workbook into specific fields. Once it copies all information in, my macro copies all active cells and paste special values to get rid of any formulas. I then need to put this sheet into its own workbook, and then save as a CSV...

Dear all, I am a consultant and expert Excel user but have come across a problem I have not been able to solve. PROBLEM I have built a financial model, .xlsm, using Excel 2010 and Win7. Originally the file was 1.6MB and was working extremely smoothly. My client attempted to make some...

Hi, I am analysing a bunch of file data and due to the large volume of data the sorts and filters take ages to run. Column B contains the size of the files in bytes. Columns D, E and F contains their last access, date created and last modified dates. Column H contains the file extension. I...

I have an Excel file that contains a lot of pivot tables with the data source being a MS Access database query. I added a field to the underlying data and pulled that into all of my pivot tables and the file size went from 108,727 KB to 648,806 KB. Any ideas on reducing the size of my Excel...

I created a pivot table that generated around 35,000 pivot table rows. I then greatly reduced the data and refreshed the pivot table so that it only generated around 200 rows. However, it looks like the 34,800 unused rows below the pivot table are still somehow allocated by the pivot table...

Hi, I have a spreadsheet that has the potential to require up to about 7000 rows, although it will, in most instances, require several thousand fewer than that. The issue that I'm running in to is that I have to fill 7000 rows worth of formulas just in case I have that much data. This file...

A little bit of searching on the site didn't lead to an answer to our specific question. We have a largish 2007 xlsx from which we deleted large chunks of validation and formatting which were no longer needed. After a save (even a "save as" to a new file), the file size did not change! Any...

Was wondering if there was any way to have a worksheet smaller than 256x65536 cells in Excel 2000 - ? Impetus for this is using a background image, which causes the file size to balloon when it tiles infinitely across & down the sheet. Hiding cells has no effect and there seems to be no way to...

I am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB - why is this disproportionate growth happening and is there a way around it - I dont want my Price...

Good afternoon All: Using Excel 2003 on XP - Using Java and an excel template, I create a very small table of data with no formulas or add-ons, basically, a simple, flat excel one sheet workbook. I make the excel file available via a standard URL link on a web site. Via IE: If I...