The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

3
votes
1answer
1k views

Pivoting concurrent start and end times into timeslots with Excel 2010 PivotTable

I've got a table of processes and their respective start and end times (calculated from the start time and duration), listed by the process ID: Run ID Duration Start Time End Time 200878 464 ...
1
vote
0answers
6k views

Windows 7 can't open Excel 2010 .xlsm files?

I just reinstalled Windows 7. When I installed Office 2010 I deselected some components to save disk space. Now, I can't open xlsm files. I would like to know which components in the Office ...
2
votes
3answers
137 views

Finding the number of specific characters inside a formula

I'm trying to find the number of of +'s in a formula inside a single cell in excel. If it were a normal cell with text inside, this would be quite easy. But due to the restrictions of the file I'm ...
3
votes
1answer
438 views

Macro Find: Is there a macro to Format a Word Document as if it were beign created in VBA?

I have a lots of code(for Excel) in Vba and would like to transfer a copy of it into a word document. Does anyone know of a macro that will format the word document to treat the code as if it were in ...
7
votes
2answers
4k views

How do I get excel to not mess around with the formatting of a .csv file

I have two issues with a csv file that occur when I try and edit it in Excel. I have an ISBN column that gets reformatted to scientific format every time I save the file The encoding for the file is ...
4
votes
2answers
5k views

Export of a custom table style in MS Excel

How to export a custom table style in MS Excel 2007/2010? I know how to export a custom chart, but I can't see how to export a custom table style.
0
votes
2answers
812 views

Summing of total with dynamics rows coming external datasource

I am using Excel 2010 and retrieving data from SQL analysis service. When I refresh the data from Excel, the rows all refresh as they are bound to an external datasource. I am adding a separate ...
0
votes
1answer
634 views

Excel 2010 pivot table data filtering

I have a pivot table with each row having an error code (say, widget defect code, with 0 being no error). I want to be able to summarize the data with total error rates, but I'd also like to summarize ...
1
vote
1answer
247 views

Excel userforms

I have developed a macro that does a whole bunch of things for me based on a few things. (Importing files). The file names are dated dd_mm_yyyy and right now I enter them into a sheet where the macro ...
2
votes
4answers
3k views

Can one list everything that uses a particular cell in Excel 2010?

I've been tasked with making changes to an Excel 2010 spreadsheet I know little about. One of the biggest changes the client wants is to remove numerous cells that are no longer needed by his ...
2
votes
2answers
1k views

How does one find the definition of a function in Excel 2010?

I've been tasked with making changes to an Excel 2010 spreadsheet I know little about. I was pretty good with Excel about a decade ago, but I'm not really sure how to look-up the definitions of ...
0
votes
1answer
278 views

Handling a big Excel File

I am managing an Excel data file (Excel 2010) which contains more than 400,000 rows and 55 columns. It is impossible to work with a Pivot table: I get a message that Excel does not have enough ...
1
vote
0answers
729 views

Excel 2010 AddPicture functionality changed?

Me again. In Excel 2003, we're using some VBA to automate adding a picture to a worksheet. The call, in a nutshell, is: Dim Pic as Object Dim filePath as String . . . Set Pic = ...
9
votes
2answers
24k views

Excel pie chart: How to combine smaller values in a single “Other” slice?

I have this pie chart in Excel 2010 (based on a pivot table): I'd like to combine all the values smaller than X% in a single "Other" slice. In previous versions of Excel, it was possible to use the ...
0
votes
1answer
169 views

Excel 2010 - How do I record a macro and play it back for all cells in a column?

I need to make a macro. I can (barely) figure this out. This macro will perform an operation on a single cell (convert link text into a live link as in In Excel, I pasted in a bunch of URLs, but they ...
2
votes
1answer
1k views

In Excel, I pasted in a bunch of URLs, but they aren't live links — how do I bulk convert them to live links?

In Excel, I pasted in a bunch of URL's into a column. However, they aren't live links after pasting. How do I bulk convert them all to live links swiftly?
4
votes
3answers
11k views

Excel 2010 data validation warning (compatibility mode)

We have some legacy worksheets that were created in Excel 2003, which are used by LabVIEW-based test automation software. The current LabVIEW software can only handle the legacy .xls format, so we're ...
2
votes
1answer
303 views

Excel 2010: How to rearrange a column into a row

I'm trying to invert columns and rows in a part of my worksheet: columns should become rows and vice-versa. How can I easily do that?
1
vote
1answer
584 views

Excel conditional formatting multiple repeating rows

I'm using Excel 2010 I have a monthly menu. menu days are listed by row with 2 menu items list for each day. Col-C Col-D Day 1 Cheesburger Hamburger Day 2 Taco Quesadilla Day 3 ...
0
votes
1answer
114 views

Creating a graph for data in Excel

I have two conditions (1-public, 2-Montessori) and a set of values based on the score of the children that is either a 0 or 1. I need a histogram showing how many children got a 0 and how many got a ...
3
votes
4answers
73k views

Keyboard shortcut to change case of text in cells in Excel 2010?

Is there a keyboard shortcut in Excel for changing the case of selected cells (to lower or upper or whatever)? All my searches lead me only to functions to do this. But that is not what I want.
3
votes
2answers
1k views

Subscripts and superscripts in Excel

I have an XL sheet with chemical formulae - which is basically just letters with numeric subscripts and superscripts. I can save as an html page and get the <sub> and <sup> html elements, ...
2
votes
2answers
1k views

Have a column with numbers starting with a 0. (EXCEL)

I have data that I want to import in excel. It's phone numbers from multiple country. For example: David France 0145535663 Luis Spain 62333331 Mike USA 5465555112 The numbers have different length so ...
7
votes
2answers
4k views

VBA Runtime error 1004: Method 'OpenText' of object 'Workbooks' failed

After an upgrade to Excel 2010 (from 2003), a script used for standardizing data from Access import has stopped working. It returns an error: "Run-time error '1004': Method 'OpenText' of object ...
0
votes
2answers
2k views

Excel Pivot Table Manipulations

I work for a Helpdesk and I am trying to create a pivot table that shows the resolution rate of our analysts. This is the pivot table I currently have shows each analysts name on the left and the data ...
2
votes
4answers
1k views

Excel formula re-calculating unexpectedly

Someone has sent me a spreadsheet (as an email attachment) where a simple sum formula has not been recalculated, as when I open the email from Outlook, it opens in Excel 2010 in protected view and I ...
0
votes
2answers
1k views

Show online/offline status of email address in Excel from MS Communicator

I got a sheet of employees in Excel 2010 and would like to see who's online on Communicator jst by looking at the sheet and the row with employee's name. Each employee has the firm's email address in ...
7
votes
1answer
1k views

Where can I find guidelines for how to use Excel's “Data and Model” cell styles (specifically “Linked Cell”)?

(I originally asked for "well-known" guidelines, but got no answers. In light of that I think it's fine is anyone just wants to answer with their own guidelines or a link to some they like.) I have ...
4
votes
1answer
2k views

Excel 2010 Macro “Command could not be completed by using the range specified”

Running a macro on an Excel spreadsheet, I get the Run-time error: 1004 Command could not be completed by using the range specified. Selected Debug and the highlighted code is: ...
0
votes
1answer
7k views

Excel formula to find frequency of occurrence of unique words in a column

I have a spreadsheet with a column with repeating number of different kinds of words like A1 A2 A3 A1 AA A2 A7 A8 A1 Now I want to plot a graph showing the frequency of occurrences of a word. The ...
0
votes
3answers
131 views

Re-ordering data in a cell in spreadsheet

I have an Excel spreadsheet where data is time stamped, but the time stamp is as follows (in one cell): Fri Mar 11 If it was 11 Mar Fri, the data would be easier to sort. How do I change the ...
1
vote
3answers
189 views

Excel plot chart from data as given in the example

I have a huge spreadsheet with simple data as follows 13:04:28 A 13:04:37 A 13:06:56 B 13:07:03 B 13:07:10 C 13:07:18 C 13:07:23 C 13:07:28 C 13:07:33 C Basically ...
2
votes
3answers
12k views

Excel and Word document In same PDF using Word/Excel 2010?

In Word and Excel 2010, you can save Word and Excel file as PDFs natively. Can you combine a Word and Excel file into the same PDF using this PDF save functionality?
1
vote
1answer
393 views

Excel 2010: Home tab is blank

A user on our network has somehow managed to empty out their home tab in Excel. I've not had much luck finding a fix on Google. Does anyone have any ideas how to fix this? The tab cannot be ...
2
votes
1answer
4k views

How to add time duration column total from Skype Call History CSV file in Excel 2010?

How to add time duration column total from Skype Call History CSV file in Excel 2010? These are my exact steps on how to set up my Excel spreadsheet. How to import Skype Call History CVS in Excel ...
1
vote
4answers
6k views

Excel do dynamic “merge & Center” based on values or through “Conditional Formating”

is it possible to dynamically apply "merge & Center" based on values or through "Conditional Formatting"? I made it possible to add colors but I want to do more advanced thing with Excel do ...
3
votes
2answers
14k views

Excel cells - show text different to the actual value?

Is it possible in Excel to have a cell show text that is different from its value? I would like to have a a cell that has the value 1,2,3 ... or 7 but it will show day of the week as text - but when ...
0
votes
1answer
3k views

Predictive text in Excel

How can I get Excel to auto complete the word I am typing by using predictive text from a defined list?
2
votes
1answer
754 views

Animate Excel Chart

I'm preparing for an Ignite talk and need to figure out how to animate an Excel chart, which will eventually go inside a PowerPoint. I would like to animate the following into a single chart/slide. ...
1
vote
3answers
498 views

Excel 2007/2010 Table Object Running Total

How do I calculate a running total in an Excel 2007/2010 table object? If you don't know what a table object in Excel is please DO NOT respond with a "=[the cell above] + [the cell adjacent]" type ...
0
votes
1answer
2k views

Export excel file to textpad each cell delimited by '|'

MS Excel export allows a csv (comma delimited) export. Is it possible to export my files from excel to .txt or csv files (all the cells in my excel file) delimited by "|" (without the quotes) instead ...
0
votes
0answers
1k views

What might cause Office 2010 Excel to crash when pasting from Access

I'm using Windows 7 and Office 2010 on a new machine so both are fairly new installations and have been fully updated. For the most part things with office have been fine, but when trying to work on ...
2
votes
1answer
269 views

Excel 2007 comment display bug with freezepanes

If I have a multi-line comment in a cell above the freezepanes row, and scroll down a couple of rows, the comment is cut off at the freezepanes point. I'm seeing this behavior in Excel 2007, and ...
0
votes
1answer
2k views

How to get rid of Excel pop up prompt when attempt to open an image? Office 2010

How can i disable the popup warning when i attempt to open an image w/ my Excel spreadsheet? The button is hyper linked with relative path to the current directory, and each button is linked to ...
1
vote
1answer
1k views

Excel 2010 Remove duplicates conditionally

I have data as noted in example below and I need to remove duplicate values retaining the latest updated value and remove the data that is in bold and italics Time Delivered Time Difference Name ...
8
votes
3answers
47k views

convert text string to date/time format

I have a column that is text formatted like 20110408_2041. How can I format it to date/time format?
0
votes
1answer
875 views

How do I enable macros when they are disabled for security reasons?

I upgraded to Office 2010. I have some Excel spreadsheets that contain macros that I would like to run. When I save the workbook as an excel macro enabled workbook it doesn't work. I get an error ...
1
vote
2answers
3k views

Compare two cells with different values in Excel

So I have two columns: Values can be "Yes - Start", "Yes - End", "Yes - Both" and "No" Values are the same as column 1 They don't match all the time, so I want to create an additional column that ...
0
votes
1answer
425 views

Excel filter by range

I am setting up a workout schedule. I have multiple rows with workout times, who is instructing the class, and who the class is suitable for. The suitable is a range, based on the following (anyone ...
0
votes
2answers
821 views

MS-Excel: How to produce a chart from data organized this way?

I have an MS-Excel chart, the data looks like this: I want to produce a line-chart from this data. The Y-axis (horizontal) will be the date range. The dates will span much more time than is ...