Top "Excel-2010" questions

The Excel-2010 tag is used for referencing the Excel Version 2010 spreadsheet application from Microsoft.

Remove a data connection from an Excel 2010 spreadsheet in compatibility mode

Situation: an Excel 2010 workbook is created using data from oracle. A data connection is created to achieve this. The excel …

excel excel-2010
Setting all Excel sheets at a defined zoom level

I have more than twenty sheets in an Excel workbook (file). Is there some code snippet or a command I …

excel vba excel-2010
Open New Instance of Excel 2010 with every file

I am using Excel 2010 and want to manage a large Excel files. So I would like to open a new …

excel excel-2010
Displaying a portion of a table in a separate worksheet

On my first worksheet in the workbook, I have a large table with multiple columns and rows (roughly a 1000 rows …

excel excel-2010
Calling web service using VBA code in Excel 2010

I am trying to write some VBA code in Excel 2010 that would consume a web service. I am unable to …

excel vba web-services excel-2010 office-2010
Microsoft Excel Can't insert new cells

I am receiving an error saying: Microsoft Excel can't insert new cells because it would push non empty cells off …

excel excel-formula excel-2010
Excel error 1004 "Unable to get .... property of WorksheetFunction class" appearing inconsistently

I have a VBA function within a spreadsheet which operates on another spreadsheet that is opened in an earlier stage …

excel excel-2010 vba
excel date formatting not working

I have an excel sheet created by a 3rd party program. One of the columns has dates in this format: "…

excel excel-2010
Open an Excel file from SharePoint site

I'm trying to open an Excel file from SharePoint using VBA. Because the file I'm looking for might be different …

vba sharepoint excel excel-2010
How to call VBA function from Excel cells (2010)?

I defined a few functions in a workbook using VBA, and then expected to be able to use them in …

excel-2010