**0**

votes

**0**answers

3 views

### Pivot Table Does Not Refresh Source

Typically, when selecting a data source for a pivot table in Excel 2013, it is possible to refresh the table by selecting "refresh table" or "refresh all". This triggers an update in the Pivot Table ...

**0**

votes

**0**answers

33 views

### Finding dates on Excel sheets

I have an Excel workbook with around 200 worksheets. Column A on each sheet is a date column.
I need some VBA which will give the names of all sheets that have a stipulated date in column A. e.g. I ...

**0**

votes

**2**answers

36 views

### Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values of corresponding cell in column B, and depending on that value, put the answer in column C.
For example, using the table ...

**0**

votes

**1**answer

15 views

### Forcing Date format

I have the the following date format 02/02/02 and I need this format to save to a csv file to be uploaded. How do I program excel to not force the date back to 02/02/2002 ? Thanks in advance.

**1**

vote

**0**answers

80 views

### excel: how to filter for a specific ID given time constraints on a text field

I have an excel sheet that has a three fields:
USER_ID | DATE_CREATED | TAGS
Tags applied to the items in the sheet vary quite a bit, and are set up like |tag1 tag2 tag3...| within the field.
I ...

**0**

votes

**1**answer

123 views

### Updating multiple links in multiple workbooks

I have 3 workbooks. Call them A,B and C.
B receives data from C via a link
A receives data from B, including data B received from C
I want to update all the links when I open A
I get that a ...

**1**

vote

**0**answers

58 views

### Copying Tables from a Website

I have difficulty making an Excel-readable file from a table on a Website.
The problems very specific to my question are:
I have to use IE 7 to access the site.
Excel is installed in another ...

**0**

votes

**0**answers

10 views

### How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2
And i have macro called "AAA" in instance 1 and "ASD" in instance 2
i want to call "ASD" in instance 2 ...

**2**

votes

**3**answers

4k views

### Excel 2007 - delete worksheet shortcut

I know the shortcut to add a new worksheet (SHIFT+F11).
But please tell me the shortcut to delete a worksheet. I spend a huge amount of time on selecting worksheet through mouse and deleting them.
...

**0**

votes

**1**answer

3k views

### How to customize Paste Value Excel Short Cut

I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...

**1**

vote

**1**answer

5k views

### How can I make filtering rows on an Excel spreadsheet easy?

I have an Excel 2010 spreadsheet that looks like this:
Department Location Staff
Accounting SF 10
IT NYC 20
Finance NYC 15
Design ...

**0**

votes

**2**answers

1k views

### How do I create a chart in Excel with dynamic series based on the data content?

How would I define a chart in Excel (2010) that shows a time series graph containing various series based on the data content itself? For example, here is a data set:
Date Series A Values
...

**2**

votes

**1**answer

3k views

### Bat file to open excel with parameters - spaces

I would like to run Excel, open a specific file in it and pass arguments to this file.
My call is
"C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE"
...

**1**

vote

**1**answer

697 views

### Have Excel's Correlation Function Respect Filtering

I've got a cell that's using the CORREL function to return the correlation of two rows of data in my spreadsheet. The issue is that I'd like this to update based on the filter that I have applied.
...

**0**

votes

**1**answer

17 views

### Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel.
Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...

**0**

votes

**1**answer

31 views

### Populate default value to a cell based on another cell content

We use a spreadsheet as our time cards. The template is stored in a server with links to it on the individual's desktops.
I am trying to figure out VB code that would help in achieving the flliwing: ...

**0**

votes

**1**answer

2k views

### How to troubleshoot “Automatic update of links has been disabled”

When I open some spreadsheets I get the error "Security Warning Automatic update of links has been disabled". I can only imagine this might be in reference to formulas or other content in the workbook ...

**3**

votes

**1**answer

2k views

### Create progress bar or milestone type graphs in Excel 2007

I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...

**1**

vote

**2**answers

2k views

### Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)

In other words, I want Excel to anchor the tick marks at 0.
I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10:
30, 20, 10, 0, -10, -20, -30
I have set set ...

**7**

votes

**1**answer

27k views

### Create a pie chart from distinct values in one column by grouping data in Excel

I have an Excel document containing information from a survey. I want to create a pie chart over location (countries).
How can I make Excel group all the distinct values together and then display ...

**0**

votes

**7**answers

14k views

### Excel automatic axis scale completely inappropriate for data

How can I make Excel use the correct scale on its graph axis? For example, I have a graph which looks like the following:
The x-axis has the wrong scale - it should range from about $3000 to ...

**0**

votes

**1**answer

888 views

### Product sales chart in Excel, from data in Access

I have a table in an Excel 2007 worksheet containing details of orders (note: I have manually changed the details to be fake on everything)
I want to count the number of products ordered for a ...

**1**

vote

**1**answer

1k views

**1**

vote

**2**answers

2k views

### Distribution of values as a graph in excel

I have a set of 1-D data (0,0,0,1,2,1,1,5,6,1,1,100,1,etc) and I'd like to generate a graph from it that shows the number of values in a set of ranges. I.e
0 - 3
1-7 - 8
8-30 - 0
30+ - 1
The data ...

**0**

votes

**1**answer

13 views

### How to move the y axis to the left in excel , scatter plot with x-axis log scale?

I have my scatter plot with x-axis log scale like below:
I want the position of y-axis moved to the left. How can I do this?

**-2**

votes

**1**answer

36 views

### Randomize Huge List - Windows 7

i've been searching for a solution for this but i couldn't find it anywhere.
I have a large list, more than 2 million entries.
I need to randomize it.
I can randomize lists in excel but excel ...

**0**

votes

**3**answers

37 views

### Average Difference and Direction Between Values in Excel with Blanks

I have a sheet that looks something like this:
Sheet 1
1 2 3 4 5 6 7 8 9 10 11
1 6
2 3 5
3 ...

**-1**

votes

**1**answer

21 views

### How can I populate other columns after user selects choice in drop-down?

I have a spreadsheet that is essentially going to be a form for our user to print out and hand to the necessary individuals. What the user needs to be able to do is select a customer number from a ...

**3**

votes

**5**answers

50k views

### Excel chart: How to reverse the X axis of time series data

In Excel 2003, I have a time series from a financial report that goes something like this:
2007 2006 2005
Amount 300 200 100
I want to create a graph of the time series that looks ...

**1**

vote

**1**answer

52 views

### Excel Pivot Table - Average per day

I have a table of data
Date Item Quantity Operator
01/01/2014 Item1 3 John
02/01/2014 Item1 7 Bob
02/01/2014 Item2 4 John
03/01/2014 Item1 2 ...

**0**

votes

**1**answer

18 views

### Comparing two strings in excel, add value for common variables

I'm comparing two large datasets containing strings in excel. Column A contains the numbers 1-1,000,000. Column B contains 1,000,000 strings, neatly organized in the desired order. Column C contains ...

**27**

votes

**7**answers

66k views

### How do you force excel to quote all columns of a CSV file?

Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?

**0**

votes

**0**answers

16 views

### Histogram - adding vertical line (x-value) - Excel

I have created a histogram from a list of data:
-0.0892 8
-0.0711 16
-0.0529 19
-0.0348 13
-0.0166 5
0.0015 12
0.0197 5
0.0378 5
0.0560 3
0.0741 4
0.0923 5
0.1104 1
I would like to add a ...

**0**

votes

**2**answers

32 views

### SUM From Sheet 1 Columns to Sheet 2 Rows

Tried searching for a while, didn't see what I was looking for.
On Sheet1, I have approximately 100 columns, each representing an item. Each row is populated by a quantity of that item. As you can ...

**0**

votes

**1**answer

3k views

### Is there a way to get a shared spreadsheet to update without closing and reopening?

Using Excel 2010, I have a spreadsheet that is used by 3 different people at any one time. But if one person has the spreadsheet open on there PC the other people can only view it as read only. I ...

**-2**

votes

**1**answer

22 views

### How to assign a unique number per group of entries in a column?

I have a list of part numbers in Column A and a location in Column S. I need to assign a value of 1 for all part numbers that are the same (A3-A16), then change to a value of 2 when the part number ...

**0**

votes

**0**answers

17 views

### Is it possible to insert multiple objects at once in Excel 2007?

My co-worker keeps a spreadsheet of candidate data, which includes the resume of each candidate inserted as an object. How can we insert multiple objects (resumes) at one time, instead of going ...

**1**

vote

**3**answers

41 views

### IF formula returns wrong value

https://www.dropbox.com/s/v6nd2z4icftmnvf/example1.xlsx
We have Excel 2007 (German) and vista ultimate.
I am trying Excel by building a roster but have run into a problem with the following formula.
...

**0**

votes

**1**answer

17 views

### Excel shows different files in same window

In Firefox, I downloaded an Excel spreadsheet and it displayed a dialog box asking what to do with it, so I selected "Open in Excel". Then I downloaded another Excel spreadsheet and opened that one ...

**1**

vote

**5**answers

11k views

### Microsoft Excel 2007 - Cannot Fit All Text Into Cell

Is it possible to fit a large amount of text within a cell in Excel 2007?
I have 1,890 words - consisting of 10,110 characters (without spaces) - that I need to put into a single cell in Excel. I ...

**0**

votes

**3**answers

6k views

### Why isn't Excel updating formulas automatically?

Excel is not working correctly for me. When I change the input of a formula, the output is not automatically updated. Could this be due to a virus? How do I get Excel to update formulas automatically ...

**2**

votes

**7**answers

15k views

### Stop excel from converting copy-pasted number/text values to date

I'm copy-pasting some data from html table into excel. But excel automatically converts some text or number values to date! When I change the format, the number is perversed, the number is something ...

**0**

votes

**1**answer

2k views

### Change numbering language of the Excel context by changing the Windows language

How could we change the numbering language of MS Excel 2010 by changing Windows language
In version 2007 as I can remember we had an option in the advanced options tab that allowed us
to do that with ...

**1**

vote

**1**answer

14 views

### Comment in fixed line in Excel gets truncated when I scroll down

I have an Excel sheet with a fixed header (first row is fixed) and some of the cells in this header contain comments. When I don't scroll down and hover over the cell, the comment is fully visible, ...

**0**

votes

**1**answer

15 views

### I want to create a format in Excel to trigger a colour code?

Currently I have a drop down list on certain cells, connected to a list of statuses. 'Complete' which marks as green, 'Pending' which marks as orange, 'Outstanding' which marks as Red. I want each ...

**0**

votes

**1**answer

18 views

### Nvidia How to display particular workbook of Excel file on TV and no matter what i do on the computer the TV displays the workbook

Basically i have a computer and a TV.I want to display particular workbook of excel file on the TV ( monitor 2 ) and when i work on my computer monitor ( Monitor 1 ) nothing happens on Monitor 2.I ...

**1**

vote

**1**answer

4k views

### Plot scatter graph in Excel graph with 3 variables in 2D

3 Columns of Data:
Date (from 1st till 31st)
Variable 1
variable 2
I want to make a simple graph where Variable 1 range is X axis and Variable 2 range is Y axis,
I plot the date on the graph ...

**0**

votes

**1**answer

13 views

### Can I use excel to read barcodes and take me to a specific cell?

I work for a community group that holds an annual fund raiser for charity over a weekend. I am an excel user and am wanting to set it up so that I can assign a barcode on a card to a specific person. ...

**0**

votes

**1**answer

24 views

### Cell in a cell excel 2013

Is it possible to insert a cell in a cell? I need to divide a cell in half horizontally. I don't want to have to insert another row as I would like it to be horizontal. Can this be done?

**4**

votes

**3**answers

4k views

### Making Excel formulas only evaluate once

Is there any way to embed the result of a formula evaluation in a cell, such that the evaluation only happens once?
For example: If I put =TODAY() formula in a cell today, if I open the spreadsheet ...