Copies of Table with Arrow Icons
I have a table called Quotes2004. Somewhere along the line two
additional tables appeared called Quotes20041 and Quotes20042, each
with an arrow icon next to them.
I understand that the arrow indicates a link. But, I don't recall
making these table copies. Can some process make the copies
As far as I can tell, they are exact copies of Quotes2004 and they are
updated when I update Quotes2004.
How can I determine how these were created, what the links are and if
they are really necessary?
To discover what a table is linked to, open it in design view.
Then open the Prope...Pivot tables #43
Product Date Volume Value
Product A 25/11/05 10 200
Product B 25/11/05 15 240
Product C 25/11/05 12 130
Product A 25/11/05 18 260
Product A 26/11/05 12 130
Product B 26/11/05 19 240
I want a pivot table that looks like this:
I have to do 2 separate pivot tables and merge then together.
Product A Product A Product B Product B Product C Product C
Date Volume Value Volume Value Volume Value
25/11/05 28 460 15 240 12 130
26/11/05 12 130 19 240
I want to the pivot table to show, so that Volume and Value for each PRODUCT
are in COL...Can I setup a league table that automatically updates itself?
Hi. I'm using Excel 97' and I'd like to know if I can setup a league table
that automatically updates itself with results from football [or any other
kind of] matches which I can just list seperately to the main table. I'm
sure I remember doing this in ancient times on Lotus 1-2-3, but I can't see
any way of doing this in Excel, although there must be some way of doing it...
...How to retrieve values from a lookup table
I want to default the OwnerID of a Case based on the OwnerID of the selected
I know how to retrieve the typename, name and GUID from a LookUp object (in
this case the CustomerID) but how can I retrieve associated values from the
You need to write a webservice to fetch the owner of the customer and than
use that webservice withs JScript in onLoad of the case to set the owner of
PLEASE do click on Yes or No button if this post was helpful or not for our
Email for direct contact: imumar at gmail dot com
"Agile CRM...Keeping Column Widths the same in a pivot table when pages increase
I've created a pivot table and because of the length of the characters
in the page, the column width keeps changing. How do I keep the column
width the same?
Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTable>Table Options
Add a check mark to 'Preserve formatting', click OK
Remove the check mark from AutoFormat Table
> I've created a pivot table and because of the length of the characters
> in the page, the column width keeps changing. How do I keep the column
> width the s...Static Chart using Pivot Table and other data
Using Excel 2000, I am trying to create a Static Chart where the source data is a pivot table and data from a couple of adjacent columns. In the past I have been able to do this. My latest chart is automatically creating a Pivot Chart without the adjacent data. How do I prevent this automation?
There are instructions on Jon Peltier's site, for creating a normal
chart from PivotTable data:
> Using Excel 2000, I am trying to create a Static Chart where the source data is a pivot table and data from a couple of adjacent...calculated field in a pivot table?
Can we use the "if" function in a calculated field of a pivot table?
Looks ok, try this thread: http://tinyurl.com/bp64n
"baabaa" <firstname.lastname@example.org> wrote in message
> Can we use the "if" function in a calculated field of a pivot table?
I have a table in Sheet1 containing various specs for a list of
A B C D E
1 Product Name Price Weight Rating Source
2 Product A $4.55 1.00 kg 47 Company X
3 Product B $10.20 3.50 kg 87 Company Y
4 Product C $8.10 2.25 kg 61 Company Z
On another sheet, I would like to use this information and I would
like to refer to it symbolically by product name and field.
For example, the other sheet might look like this:
A B C D
...Intelligent Message Filter #3
I recently installed IMF on my front-end server, but it doesn't appear to be working correctly.
I've enabled it on the SMTP virtual server and have set both the gateway blocking and junk e-mail config to an SCL level of 5, (and rebooted) with suspect e-mail to be archived. We run mostly Outlook 2000 clients for now, with some Outlook 2002 and 2003 clients.
What I don't see is 1)the 'archived' folder in the default location of program files\exchsrvr\mailroot\vsi 1\'archive' or 2)any activity whatsoever on any of the performance counters for IMF.
Any advice w...Manual sort in a pivot chart/pivot table
My goal is to change the order of 4 row lablels. They are all text, and I
have to choose the order (not alphabetical).
I got as far as clicking on the arrow next to Row Label on the table, going
to More Sort Options and then choosing Manual Sort. HOWEVER, where/when do I
grab the labels to "drag" them to the right order? I have tried clicking on
the table itself and clicking on the chart but there is no dragging
happening. I can't find any detailed info on Manual Sort in the Help box, and
so I'm stuck.
Thanks in advance!
You can click on the cell containing label an...Pivot Table Error: Cannot group that selection
I'm trying to group invoice dates in a pivot table by
month and year. Too bad there is no "reason" button? heheh
Any suggestions are greatly appreciated
You'll see that message if there are text entries or blank cells in the
column of dates.
> I'm trying to group invoice dates in a pivot table by
> month and year. Too bad there is no "reason" button? heheh
Excel FAQ, Tips & Book List
Thankyou... but I've checked that all d...Grouping in Pivot Tables #2
I have a table which has Job Number on the left, with inner division
by Revenue/Cost Group, then individual Cost or revenue codes. Along
the top are year and month columns.
I have manually selected which cost or revenue codes to include in
"Revenue" group and "Cost" group by highlighting etc and it all looks
OK at the moment. There are about 60-70 cost/revenue codes so this is
a bit of a pain.
The cost/revenue codes are alphanumeric and are not consecutive in our
chart of accounts. Codes are usually of the format LNNNLLL. Individual
jobs use a subsection of the...Pivot Table
Operating System: Mac OS X 10.6 (Snow Leopard)
I have one category row and 2 data fields right now the data fields are stacked, how to I get them to be side-by-side? <br><br>Now <br><br>Category Data <br>
Administration Sum of Amount <br>
&...Solve Order of a CalculatedField in a Pivot Table
Does anyone know how to get the Solve Order of a CalculatedField in a pivot
I know how to get the Solve Order of a CalculatedItem but can't seem to
get the CalculatedField!!!
An example of getting the Solve Order of a CalculatedItem is...
Any help would be appreciated.
Thanks in advance.
...Add Data To Pivot Table
I made a report, requested by our sales reps, that
included sales figures for various customers and
territories over the last few years, showing month
to month totals per rep. But ...
How can I update the report on a monthly basis now?
Instead of having to go back and run the whole report
over again each month, I mean. I just want to be able
to add in the next month's totals to the figures already
in the previous report, but I see no way to 'undo' the
previous setup to add in the new stuff, or merely combine
the new figures with the old.
What am I missing? Any help ap...Adding columns to item table
Are there any incompatibility issues I would need to worry about in
adding additional columns to tables in the database? I'm already
using most of the available fields in the item table and I would like
a place to store each items ASIN assigned from amazon. I don't need
to be able to read or write this in either the POS or the Manager, I
just need to be able to access it through SQL queries.
I would like to know the same thing. Has anybody done that without problems?
<email@example.com> wrote in message
news:firstname.lastname@example.org......I need to track stats for my pool league.
I am the new treasurer and statustician for a billiards pool league and I
have to make up all of the programs myself. I haven't a clue as to how to do
this the easiest way. Any suggestions? Thank you in advance.
"Jody" <email@example.com> wrote in message
>I am the new treasurer and statustician for a billiards pool league and I
> have to make up all of the programs myself. I haven't a clue as to how to
> this the easiest way. Any suggestions? Thank you in advance.
Then ...Outlook 2003 Crashes
Event Type: Informatio
Event Source: Microsoft Office 1
Event Category: Non
Event ID: 100
Time: 11:44:15 A
Bucket 99179544, bucket table 1, faulting application outlook.exe, version 11.0.5510.0, stamp 3f1380f0, faulting module ntdll.dll, version 5.0.2195.6899, stamp 4060ef9b, debug? 0, fault address 0x0004c8e1.
0000: 42 00 75 00 63 00 6b 00 B.u.c.k
0008: 65 00 74 00 3a 00 20 00 e.t.:.
0010: 39 00 39 00 31 00 37 00 220.127.116.11
0018: 39 00 35 00 34 00 34 00 18.104.22.168
0020: 0d 00 0a 00 42 00 75 00 ....B.u
0028: 63 00 6b 00 65 00 74 ...indexing in a table
Can anyone confirm (or deny) that when indexing in a table is set to 'Yes -
No Duplicates' and then you try and append data from a sorted query into that
table, DOES THE TABLE ALWAYS ACCEPT THE FIRST ROW (as sorted by the query) or
is it more random than that.
On Sun, 28 Feb 2010 14:19:01 -0800, sdg8481
SQL is not random. In fact it is firmly rooted in mathematical set
theory, and all its operations are 100% predictable.
If you meant to ask "I have another table that has data that would
violate t...Linked Table Manager
How to use VBA to open up the "Linked Table Manager"?
"Paul" <firstname.lastname@example.org> wrote in message
> How to use VBA to open up the "Linked Table Manager"?
...Building a query from three tables with differing infomation
Hi - Not too sure if this is possible, or if i'm being a dillweed! And
please bear with me - it may seem a long explanation but it does get there in
I have an CSV file that has to be imported every day, with the following
DATE, Client, Client Name, M/House No., Mailing House, Notified Bags,
Notified Items, Receipted Bags, Receipted Items, Outstanding Bags,
Outstanding Items. This file is normally around 15000 rows
I then have to remove the Notified Bags and Items and the Outstanding Bags
and Items, sort this by Receipted Bags, Remove all zero entries -...Problem copying pivot table
I created a Pivot Table in an Excel file sent to me by a
co-worker. She sends a updated file each month with the
same layout, and I use the Move/Copy Sheet function to add
my Pivot Table to the new file.
The problem is, the table still points to the
consolidation ranges in the file I copied from. So, I
must manually redefine all the page fields to point to the
I need to automate this. Can someone help me?
if i am making sense of what you're saying---try doing it
the opposite way--instead of copying your pivot table to
the new data.....How do I search an entire table for a given values?
I have around 13 columns in a table and building a front end where
user enters a value in a text box and hit submit and the SQL query
should return all the rows that matched columns with the value entered
by the user.
Can some one please help me with how to come up with a sql please.
Actullay I need to write this in Oracle 10g but I am trying it to work
in SQL server and hopefully it works the same in Oracle too. I do not
have the much data in Oracle on the test box so trying to get it
working in on my sql box. The below simple sql seems working OK but
want to know if it ...Football League Table
Does anyone have any ideas of how I could create a football (soccer)
league standing that is automatically updated every time new scores are
Message posted from http://www.ExcelForum.com/
Look for posts by Bob Phillips in www.google.com
I believe he has created one for the Premier league (since you say football
before soccer I assume
you are from the British Isles)
I know he has emailed an example to other posters upon request,
can't guarantee anything of course..
"12345" <email@example.com> wrote in ...cell comments in a vlookup table
i have information in a vlookup table that i only want to veiw when
required.It cannot be done with cell coments as these do not come over within
a lookup table.I thought of another column within the lookup table,but these
are always visible, and i am running this program on a P.D.A and space is at