external datasource

  1. F

    Code to Hide Rows based on criteria in linked cell

    I have read about 50 threads and cannot seem to get a macro code to work and I am not well versed in VBA so I have been trying to cut and paste certain codes to get to one that works without success. My workbook contains an "Expense" tab and a "RPT" tab. The RPT! tab pulls data from a separate...
  2. L

    How to make excel stop putting a hyperlink in my lookup formula after exiting the file

    I made a calculator that grabs data from an external online reference. On the first sheet I have a link that is =HYPERLINK("http://www.wowuction.com/us/illidan/horde/Tools/RealmDataExportGetFileStatic?type=csv&dl=true&token=5L7U_r_iGWpMkMqHHmfPgQ2","Refresh") refresh is just the name it appears...
  3. S

    Excel file size due to pivot tables

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

This Week's Hot Topics

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
Top