Top "Excel-2010" questions

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

Custom Formula for Grand Total column

I have a frequent problem where the formula I want to use in the Values area in my Pivot-Table is …

excel excel-2010 pivot-table powerpivot
Open XML SDK 2.0 to get access to excel 2010 worksheet by name

I have an Excel 2010 spreadsheet that has 3 worksheets named Sheet1, Sheet2 and Sheet3. I'm trying to get a reference to …

c# openxml openxml-sdk excel-2010
excel 2010: text to columns is remember, how to get rid of this?

I have tekst copied from a pdf file to Eexcel(2010). I used 'text-to-columns' to create separate columns. Now I have …

excel text excel-2010 multiple-columns pasting
How to get the last modified file in a directory using VBA in Excel 2010

Im looking for a way to do this in Excel 2010 using VBA. It used to be possible in Excel 2003 using …

excel vba excel-2010 file-search
Saving new Excel document as macro-free workbook without prompt

I'm using Excel 2010. I have an Excel macro-enabled template that has a data connection to a text file that is …

vba excel excel-2010
Refreshable Web Query using Excel 2010 and Parameters

I'm looking to pull into the XML feed from Feedburner's API. This is just a matter of writing the URL …

excel excel-2010 excel-web-query
How to put user defined datatype into a Dictionary

I'm trying to define my own data type and put it in a Dictionary as a value. VBA complains that …

excel vba excel-2010
Line breaks in generated csv file driving me crazy

I'm trying to make an export of some data i have (stored in a datatable). Some of those values have …

c# excel-2010 csv
online tool to extract and crawl data from website with URL list into excel

Is there any online tool (without installing software in computer) to extract data from website with a list of URL. …

web-crawler excel-2010 extract web-content
Pasting an array of values over a ListObject (Excel table) destroys the Listobject

In one of my worksheets, I have a Private Sub BuggingVba() That should replace the data in a table with …

excel excel-2010 listobject vba