2016

  1. K

    Pivot table not picking up row with same data

    Took my first step into the wonderful world of pivot table, but i can't seems to word the following problem into the search bar. Duplicate data, data not picking up etc all leads to range error, but I'm sure its not a range error. (or is it...) I managed to make the desired report as customer...
  2. E

    Excel 2016 having trouble creating a Word document using a template

    Earlier versions of Excel and Word were not having this problem. I'm getting this error: Run-time error 5981 Method 'Add' of object 'Documents' failed. Set wdApp = CreateObject("Word.Application") 'Create an instance of word Set wdDoc = wdApp.Documents.Add(QuoteDirectory &...
  3. A

    Can I recreate Excel 2003 type toolbar and menus in Excel 2016?

    Hi all, I registered just to ask this question. I considering upgrade to Excel 2016 from 2003. I'm still using Excel 2003, but considering finally making update to Office 2016. The reason I'm still using Excel 2003 is comfort with the toolbars vs. the shock I experienced when trying to...
  4. R

    Excel 2016/Windows 10 Personal.xlsb file opening hidden rather than desired file

    I have a personal.xlsb file with a couple macros in it (no start up macros), and Excel won't open files I'm trying to click on to open but rather just opens excel to the hidden personal.xlsb sheet and never opened my desired file. I'm sure it must be a bug, is there anything besides deleting...
  5. F

    Macro from Excel 2013 fails to work in 2016?

    Hi, I have been using a macro to save an image on my company's invoice. I have been using this from past 4 months without any issues. But recently we upgraded from Office 2013 to office 2016 and now the macro fails to work properly. I have no idea why. Can someone please help me fix the issue...
  6. S

    PowerPivot 2016 updating, but not connected Pivot table

    I have made a PowerPivot 2016 connection to Microsoft Analysis Services yesterday. Yesterday is 2015-12-09 (dec. 9th 2015). The connection has then been used in a Pivot table. Everything worked fine. Today when I update the Excel 2016 sheet, there is no extra data from yesterday. Then I go to...
  7. V

    Range sliders

    Dear fellow members, I'm looking for help in doing range sliders in Excel like described here (Range Filter Slider Control in Microsoft Excel - Clearly and Simply) the only problem I have is that this solution doesn't work on Mac (both 2011 and 2016 versions). May be there is a solution which...

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