HI , I have 5 pivot tables , 3 are connected on 1st raw data and other 2 are connected on 2nd raw data and I am trying to refresh them using both Excel refreshall button or Alt+f5 and I even tried macros(activeworkbook.refreshall) but It's not working for the first try , All I need to do is to...
I just updated my MS Office from 2010 to 2016. All has gone fine however on one file where I have code to calculate distance between two points it has seemed to stop working. Anyone got any ideas here?
Public Function GetDistance(start As String, dest As String)
Dim firstVal As String...
Hi,
I have assigned a code in Userform for the command button to update data as per the input in the Textboxes in Excel.
However, after clicking OK (command button caption name), I want the data to be cleared in the form and also after inputting more data in the form, the OK button should add...
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.