I just wanted to see what you guys think of this method for creating dynamic 4 color data bars. The idea is this take the cell that will hold a target number and then base its data bar off of an adjacent cell that is either calculated or programmatically populated. As the variable cell value reaches the target value, the data bar travels along the target cell as normal, yet, also changes color as it reaches certain thresholds during its travel. A portion of this solution was obtained from http://blogs.msdn.com/excel/archive/...24/538875.aspx.
Please note examples 2 - 6 are only to show how the data will look when C14 or D14 is changed. The [list] per se will only work if just one row is the data that will be manipulated. There might be optimizations to this solution out there. If you have one please let me know...
Here is a screenshot
Hi friends!,
I have a data file, and another file with some pivot tables on different worksheets, each reading from the data file.
I am trying to write some code in the data file that tells the relevant pivot table to refresh anytime data changes in the source table. What I wrote doesn't work. I have pasted a sample of what i came up with, below.
Private Sub Worksheet_Change(ByVal Target As Range)
[file_name.xlsm] worksheet_name!.PivotTables("PivotTable1").RefreshTable
End Sub
Could anyone help me correct this code, or give me a better way to do this?
As always, I am very grateful for any ideas and suggestions.
I've created several table queries in Access 2007 that run as expected. In Excel 2007 under the data tab you have the option to "Get External Data" "From Access". In most cases I would select the database and see a list of tables to link to the worksheet. I've created 4 today that I can see in Access that don't show up in my options for Excel. The list of tables doesn't give an option to refresh and I've tried exiting both programs and starting over. Any ideas?
-goodluck
Hi. I just noticed that in the new office package (2007) the lines from Excel remain when i copy tables into Word. Is there a fix for this?
Thanks,
/Mads
In Lesson 4 in "Grouping Fields" part, in the following paragraph:
" At present, our Names heading is the inner most row field. Lets change that now by left clicking on our Date of Birth field (column heading in C4) and dragging it to the left and dropping it in A4 so that it becomes the inner most row field (left). Now select Group Selection under Group optionson the Options tab, scroll down and highlight the word Year ensuring the you unhighlight Months. "
When we want to change "Date of birth" field, you mention that it is in column heading in C4, but the cell C4 is empty there is no data. The same thing happens for Age field.
Therefore, we can't group by those fields, because we can't do them the inner most row fields.
Unfortunately I don't know VBA hardly at all. If I'm pointed in the right direction I can usually piece together what I need.
Currently I'm working on a project which involves a table in Excel that has data dependant on other data. I need a way to have Excel select at random an item from Column A, randomly select another item from Column B within the data range under Column A, then all the items within that range under Columns C, and D.
http://img3.imageshack.us/img3/981/dataexample.jpg
The second part, is there a way to have Excel send the random and gathered information to an XML format or XML file?
Thanks in advance for any advice.
-Mike
P.S. Sorry for the image starting the data on Column B. It's just an example, not the actual table as the table itself has some sensitive information in it. There are some blank cells in the actual table also.
Hi all,
I'm having an issue regarding Pivot Tables and my column header names. The problem is that my column header names can change at any time and the user can do this at any time. However, my pivot tables are obviously designed to use that specific column with a specific header name when you first create it.
For example, if I have 3 cells: B1 with the value = "Year 2010", C1 = "Year 2011", and D1 = "Year 2012". The pivot table will use those titles for the actual pivot table produced ("Year 2010", "Year 2011", etc)...
The issue is when the user can change B1, C1, and D1 later on... perhaps they can shift it to B1 = "Year 2011", C1 = "Year 2012", and D1 = "Year 2013".
If they do this and refresh the pivot table, the pivot table won't work. Is there anyway to have the Pivot Table understand what's going on (that just a simple name had changed for that column, but still to get data from that column)?
Thank you all.
I can't seem to find the Window > New Window in excel 2007. I am also looking to split a window as well which should be Window > Split but I can't find this option in excel 2007. Where are they-have they changed name? Thank you
Hi,
I have the following table with the first rows merged to indicate the years. When I insert tables in excel 2007, Excel seems to add the word "Column" in empty cells and I cant seems to delete the word "Column".
Here is sample how the table looks before inserting the table and after the table is inserted.
Is there any way I can delete the word "Column" ?
Sheet3
*
B
C
D
E
F
G
H
I
J
K
2
Before Inserting Table
*
*
*
*
*
*
*
*
*
3
Year
2006
2007
2008
4
Dept
M1
M2
M3
M1
M2
M3
M1
M2
M3
5
Staff
200
200
200
200
200
200
200
200
200
6
Dependents
380
380
380
380
380
380
380
380
380
7
*
*
*
*
*
*
*
*
*
*
8
*
*
*
*
*
*
*
*
*
*
9
After Inserting Table
*
*
*
*
*
*
*
*
*
10
*
*
*
*
*
*
*
*
*
*
11
Year
2006
Column1
Column2
2007
Column3
Column4
2008
Column5
Column6
12
Dept
M1
M2
M3
M1
M2
M3
M1
M2
M3
13
Staff
200
200
200
200
200
200
200
200
200
14
Dependents
380
380
380
380
380
380
380
380
380
Excel tables to the web >> Excel Jeanie HTML 4
Appreciate assistance. Thanks.
