file size

  1. B

    Power Query File Suddenly Exploded to very large file size...why?

    I’ve been using Power Query (2013) to import several Csv files, process them, run a couple of merges and dump the final tables in worksheets in excel None of the files are very large (less than 200 rows). I’m using staging queries to pull in the data and then separate loading queries to output...
  2. M

    File size shrank suddenly?

    I've been periodically saving my database in a separate folder, and I just noticed my database file is now down to about 5kb, down from about 60 MB. What could have happenned? I did not split anything or compact anything, they are both identical as far as I can see.
  3. J

    Massive File Size Increase - Clues on how to correct?

    I have a file which brings a dispatch list (copy/import), and combines the dispatch (jobs & dates) with a file located on the server (descriptions & rates) and shows them on another sheet in my main file (working_dispatch). I recently moved my network files to a shared drive so multiple...
  4. R

    Last Row is Always Row 1048576

    Hi all, I'm running into an issue that I can't seem to solve. My sheets are going to the absolute last row and are drastically impacting the file size of my workbook. Excel seems to think that my sheet goes to the very last row, even after clearing contents and deleting rows. This is turning a...
  5. A

    Excel File is TOO Big...using Offset Formulas

    Each month I create a report with over 100 summary tabs that are referencing 22 data tabs. All tabs are in the same file. The report works great! It is easily manipulated for all of the one-off requests I receive and the information is well presented and useful to my many customers. My...
  6. J

    Extract file details from folder and subfolders - VBA

    Hi everyone - I found this great code below that extracts the file names for all files in my folder. I was wondering if anyone knows how to also add the: "file path"; "file size"; "last modified date"; and "last modified by". Please let me know if you have any thoughts! Sub Auto_Open()...
  7. T

    Excel 2016 Bug?

    Folks, Without really explaining what I do for a living (not sure its relevent), I wanted to explain both a bug I have been experiencing as well as the typical overall workspace I'm using: First of all, I have Excel 2016 now and I use 'Excel.exe /x' in Windows 10's 'Run' prompt to have open...
  8. A

    Size breakdown of a workbook

    Is it possible to display the size breakdown of what makes up a workbook? For instance a breakdown of how much of a workbook file size is due to the data, or objects, or forms, or formulas, etc. :confused:
  9. B

    Import text function taking significantly longer than usual?

    Hello, I hope somebody can help me with a recent issue involving the import of text data. Excel 2013 Professional Plus 32bit, Windows 7. I have a workbook that I have scripted to import a General Ledger Detail, in CSV format, categorize the data and populate it out to about a dozen...
  10. D

    Small File, Low Performance

    Hello, I have an Excel file that is larger in size than it 'should' be. The file is a simple template that is placed on a network drive and updated by between 2-3 dozen people on a daily basis. It's 14 sheets, but should only have about 20 rows and 10 columns of data per sheet. When the...
  11. P

    Csv file size is too big

    Hi, Help please, i have created a master list of all our products, approx 5,864 lines with 26 columns. I have just added in approx 1200 items and when exported as a CSV file the size is 94mb, the previous version was approx 1.2mb. There are no links to external data sources and there is...
  12. D

    File Size Possible Issue (Downsizing ideas?)

    I have an Excel file (I don't consider it to be too big (88,000 KB) that also references one other data dump file so sometimes caches an extra 42,000 KB. When end-users are using the file and actually in the file, everything runs very quickly; however, I am starting to get complaints on how...
  13. T

    Msgbox to display file size of an active workbook

    Hi Folks: I have seen many version of this, but not this request I was hoping to display the file size of an active workbook within a msgbx. I do care about the size of each worksheet,; I was also hoping to name the path and workbook. Thank you!
  14. B

    Huge file - new suggestions please

    So I have looked through previous threads and tried suggestions but I can't seem to decrease the file size of my Excel 2007 document. I have 4 tabs in one workbook. 2 tabs appear to have normal data ranges (based on the scroll bar size) and the other 2 tabs appear to be huge. In the one tab...
  15. A

    Size of file seems to be preventing macros working

    I have a 3.2MB file, containing lots of formulas. The macros are no longer working (can't be done with available resources...) What can I do? I don't want to delete any of the formulas or macros Thanks
  16. C

    HELP PLEASE: VBA List Folder size and File size, but not include subfolder

    example: i've "A" folder at "D:".. Floder "A" have folder "B", "C", "D", file a-z.. And folder "B", "C", and "D" have a lot of files at each folder.. Can i list just folder "B", "C", "D", and file a-z; without file in folder "B", "C" and "D"? I want name folder/file and the size.. THANKS>>>
  17. P

    DSUM referencing an external file causes file size to increase massively

    Hi, I am analyzing a large amount of data for a project, and so I am attempting to use the Database functions within Excel to speed up the analysis. However, after I set up the first set of DSUM equations, my file size jumped from ~50k to ~40MB! Any help would be much appreciated. Here are...
  18. Panos

    file size

    Hello, I work on a file (xls) with approx size 7 mb. My problem is that this file was 4.5 but after something unknown I add, the file jumped to 7mb. It is strange that when save the file and exit, it is 7 mb but if I open again, save on the main worksheet and exit without doing something else...
  19. Panos

    Store formulas in vba in order to reduce 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...
  20. A

    Copying sheet to new workbook and saving as CSV

    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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top