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

Bill_Kro

New Member
Joined
Oct 28, 2017
Messages
14
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 the results after merging and appending.

I’ve been saving different versions as I’ve been progressing. I just noticed that the file size has exploded from under 1mb to suddenly 44mb.

Any my idea why? What info is needed to diagnose?

Thanks
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Problem seems to be solved.

I think the file must have been corrupted.

I solved the problem
1. Created a new file
2. Copied all the queries from the old file
3. Pasted the queries into the new file

File size is now back down below 1MB

I had to reformat the output tables in the new file, but not a big deal
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,044
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top