A team I'm working on used to manually process data received from clients writing out their PDF documents into an ever growing range of data within Excel. We only have access to Office 365 programs and Power Query has been a real game changer, but we're all pretty new to it.
We've been...
Is there a way of selectively importing data - have a csv file that is around 126 million rows and 3 columns. The third column will be a number between 0 up to around 1,000.
Is it possible to request that a row is only imported if, say, the value in the 3rd column for that row was less than...
I have a 2010 Excel file with three tabs, one that only has any data on it... and it only has 26 rows and 34 columns that have any data??? the file size is 5.2MB??? same file saved as 97-2003 is more than half the file size smaller at 2.1MB??? Can anyone help! Thanks, Sybo2
First . . . I did search the Internet, found some similar-sound problems, but none of their suggestions worked. . . .
I am using Excel 2007 on Windows Vista (Home edition). For months I have been developing some VBA code for Excel, with no problems. All of a sudden, I constantly get the...
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.