The Excel-2016 tag is used for referencing the spreadsheet component of the Microsoft Office 2016 suite released 22 Sep 2015.
I'm trying to refresh a query on a cell change, however I can't figure out how to reference the query. …
vba excel excel-2016I am calculating all the hours/minutes/seconds of all calls made on our PABX system. The cell has to …
excel excel-formula excel-2016I'm trying to connect to an Oracle Database on our server from an Excel sheet, but am having trouble understanding …
database excel oracle oracle12c excel-2016In my Excel 2016 project (Windows 7), I'd like to work with the clipboard: Dim DataObj As New MSForms.DataObject DataObj.GetFromClipboard …
excel vba windows-7 excel-2016Visual Studio 2015 is giving me an error stating that the "Namespace or type specified in the Imports 'Microsoft.Office.Interop.…
vb.net visual-studio-2015 excel-2016 office-2016When I try to insert it, I constantly get the "Cannot insert object" error. It seems to be a known …
excel vba excel-2016If I have the following table (shown in the image below), how can I write a grouped query that would …
excel group-by powerquery excel-2016 mmy application basically accepts an excel file and uploads data to my database which used to work perfect with Excel 2010 …
c# excel oledb excel-2016 office-2016I have a sheet with a bunch of data. I then have a different sheet that references multiple cells in …
excel excel-2016I'm having trouble using ODBC to connect from Excel 2016 to a PostgreSQL database. I tried to follow this answer, without …
sql excel postgresql odbc excel-2016