2016

I am a complete noob to VBA. We have a macro that runs fine on Excel 2013 but gets a Run-time error on 2016. The part of the macro where it hangs up is trying to copy and paste merged cells. The error states "To do this, all merged cells need to be the same size." They are the same size. It...

I am looking for a way to document how pivot table summary calculations are put together. Sum Count Average Max Min Product Count Numbers StdDev StdDevp Var Varp and how they are used with cell values.

This has to be the strangest bug I've ever seen in Excel. I created 2 slicers that control numerous pivot tables. In VBA, I check who the user is on login and then loop through the slicer names to set their name as the only one marked as true. Simple code right--the same code I have done in...

In Excel 2016 How Do I add certain tools to my ribbon? Every single time I try to use certain tools in excel, they do not appear in my ribbon for me to use. Why? and how can I add the tools to my ribbon? Thank you!

Hi fellow Excel professionals, I searched the Web and the forum, but didn't find the solution for a problem very similar to one regularly and recently discussed. I have to draw dynamic bar chart colored red, amber, or green depending on whether the value crossed the limit. That is an easy part...

Hi all, I've been googling high and low for the meaning of "step size" in the function FORECAST.ETS.STAT, but I couldn't find anything beyond "Step size detected Returns the step size detected in the historical timeline." What does this mean, actually? This is one of the sources I referred...

Problem Working with various in-congruent data tables of 100+ columns & 200-500k records, "Clearing Contents" of 'blank cells' takes*: "Blank" Cells Defined - A1:B10; C15:E25; BB2200:BC300000 Ranges contain "blank" cells that Excel counts in Pivot Table summations. - LEN(ranges) = 0 Various...

Hi i have a job to do which involves creating a large number of charts from a series of Excel 2016 data sheets and pivot tables built on this data. The process requires judgement on what to chart and so i don’t really want to get into writing macros I don’t think. I have set set up a series...

Hello, I have got a Excel Spreadsheet which upon opening runs a macro which opens all .tsv files in a folder and creates them as Worksheets in Excel with the same name as the file. The name of the sheets are based on Dates and will be changing regularly, once it's over 8 weeks old it will be...

Appreciate help with understanding how a VBA macro that works fine in Excel 2010 and 2013, but that generates an error (Run-time error '1004': Application-defined or object-defined error) when executing in version 2016 explicitly. The macro is embedded with a sheet in a workbook (the "Index"...

I recorded a macro in 2016 and it works fine. Two other users on 2016 have also used it with no issues. I sent the file to a user on Excel 2013 and they get an Invalid Procedure Call or Argument error. I even tried recording the same macro from their computer and it gives me the same error...

Hello, I would like to create a VBA to automate the "Compress Pictures" in a batch. I've been searching the forum and realize that the Excel 2016 version do not have such code exist, however, this can be done by some "Keyboard alt key" recording. Unfortunately, I can 't find any solution for...

Hello all. I have an inventory workbook that uses data slicers to drill down to specific criteria. The worksheet that displays the inventory has the product models in columns going across the worksheet. The rows going down are the locations where the product is housed. There is a module of code...

Hi. Does anyone know why Excel won't insert anything in the recipient field? When I use it on my computer it works, but when a collague of mine is trying it it won't. We are using Excel 2016 Could it be something about acsess? This code is only part of the whole thing, but everything else...

Hello, How can a recordset of data from a database or someplace else be copied / overwritten into an existing Table in Excel 2016. Thank you dear All for your help.

Hello and thank you for your time. I have created a report that is shared with clients that has a private sub for when the workbook opens. One of my clients is getting an issue with the bold line of code. Here is some basic information: I wrote the code/created the workbook in Excel 2016...

I have a macro that works fine in Excel 2010 and 2013. It copies a range from excel, saves it as a jpeg on my c drive and then emails the save file using outlook. I have recently upgraded to excel 2016 and the macro no longer works and i don't know why. I would be extremely grateful if anyone...

Hey guys, I have an issue transferring this code from Windows VBA (where it works) to Mac. Both are Excel 2016. Dim x As Long x = Worksheetfunction.Sum(Range(Cells(2,3),Cells(y,6))) If x <> Range("F3").value Then MsgBox "Hello" End If So, on Windows "x" = Range("F3").value and so the message...

When I create a pivot table, the default setting in the box “Add this data to the Data Model” was checked. The consequence is that creating calculated field (and items) and grouping is disabled. I have now changed the default setting. My problem is that I have many pivot tables (mostly by...

Folks, Without really explaining what I do for a living (not sure its relevent), I wanted to explain both a bug I have been experiencing as well as the typical overall workspace I'm using: First of all, I have Excel 2016 now and I use 'Excel.exe /x' in Windows 10's 'Run' prompt to have open...