How can i display the equation from a graph in my table
I have just finished creating a number of graphs each with 9 series of data.
I was wondering if there is a quick way of copying the Power trend equation
for each series in my original worksheet rather than having to copy and paste
and then modify the equation to formula style.
Thanks very much
...Calculating difference on Pivot Table Totals
I have a pivot Table as follows
Region State jan Feb ... Columm
North NY 1 5
NJ 5 1
North Total 6 6
South FL 2 6
GA 6 2
South Total 8 8
Grand Total 14 14
I would like to change the display of Grand total to show the difference
between the region as follows
Grand total difference (2) (2)
Any help on this is greatly appreciated.
...pivot table subtotals
I'm stuck trying to develop subtotals in a pivot table. I hav
successfully placed Sums of the individual elements, but I'd like
"Subtotal" line for specific types of elements i.e.:
1/22 1/23 1/24
All of thee above rows/lines calculate just fine except the GroupX Su
Does anyone have any suggestions on how I can get subtotals to wor
Message posted from http://www.ExcelForum.com
Double-click on the field button at the top of the Group column.
Un...Add database fields to Activity
Can anyone please tell me how to add fields from the CRM db into an activity,
similar to how it's done with email templates?
Is this possible?
Thanks so much.
in this release you cannot customize activities. This feature is slated to
appear in the next CRM release.
Microsoft CRM MVP
"Mitch" <Mitch@discussions.microsoft.com> wrote in message
> Can anyone please tell me how to add fields from the CRM db into an
> similar to how it's done...how to prevent simultaneous access to a table?
Students can subscribe for any project via a webform. Table 'project '
contains all the proposed project and table 'student' contain the name of
the student and the project-id.
Now, suppose there is a limit of 4 students for project 'A' and there are
already 3 subscribed students for that project. One more student can choose
that project. The code checks whether the limit is not reached (by counting
the amount students for that project in table 'student') before inserting
that student in the table 'student'.
My problem is that whe...Cannot Reference EXE?
On .NET 3.5, I have a console application with some public classes. I
referenced them in my web appliacation project, get good intellisense,
and the project builds. When I run the web app, a .aspx calls an
internal .cs that calls code from the exe - I then get an error about
not being able to find the namespace.
converting the .exe to a .dll works fine, so there must me something
wrong with the binding/reflection ability of asp.net web app - what
can I do to fix this?
> On .NET 3.5, I have a console application with some public classes...references
I have obtained a "publication" that seems to have
references in the footer to headings in the text area. I
would like to accomplish a similar thing but can't see how
the original document did it. Also, are there other types
of referencing available? For example, I'd like to print a
semi-TOC on the first page of a newsletter without having
to pre-print the newsletter to see which page which
article is on. Also, I'd like to be able to reference a
pseudo-bibliography entry on the last sheet from articles
within the newsletter. Can that be done? If so, how?
Thanks ...Reference another sheet...
I want to have a validation drop dpown on sheet 1 and have the data for the
validation on sheet2...How? Thanks Bill
The other-sheet-data should have a name:
- select you cells
- click in the Name box (Formula bar left, where you see A1)
- type a clear name
- select your validation range
- Data-Validation-tab Settings
- Allow: select List
- Source: press <F3> and select your name
Hope that will do.
"Wild Bill" <firstname.lastname@example.org> wrote in message
> I want to have a validation drop dpown on sheet 1 an...Pivot table #17
I have a big database (am using excel 2000) which is sorted on Invoic
no. wise & then Itemno. wise. I have 2 queries:
1. I want a summary which shows Invoice no. (Key column), Item no.
other details of the database. But the summary pivot (using format no
5 of Format Report command) shows the Invoice no. once and then th
item details. what i want is that the invoice no. should repeat itsel
everytime with the item detail. is there some method for doing th
2. In the same table we also have some text columns and some dat
columns. Can these columns be shown as it is in the pivot tabl
su...Supress Zero Values on Pivot Tables
I have pivot tables created and results have many rows that have zero value
on a certain column of it. How can I get the pivot to show only those rows
that have value higher than zero. Thanks.
...Custom Field to display start time in Hours and Minutes
I'm new to Microsoft Project and I'm just finding my way around but I'm
struggling to find out how to display the start time field in hours and
minutes, if I try a custom field I can display one or the other and if I try
to concat both all I get is #error in the field where usually if I mess it up
it'll tell me there's an error in my syntax.
Could somebody help a noob out?
For Project 2007:
Tools, Options, View, select the Date Format on top of the list. All dates
will now include time of day.
Jan De Messemaeker
Microsoft Project Most Val...Saving Formatting in Pivot Tables
When I changed formatting in a pivot table, it returns to
the default format when I make a change or close the
file. Generally, in formats like font size, column
width, etc. Is there a way to save/retain format changes
in pivot tables?
right click in the table and go to the bottom to
select "table options". It's there.
>When I changed formatting in a pivot table, it returns
>the default format when I make a change or close the
>file. Generally, in formats like font size, column
>width, etc. Is there a way to...Cell references
If someone could help me, I would really appreciate it! I am using the LARGE
function to return certain values from a list of numbers. For example, I
have the following data:
In part of a spreadsheet, I have LARGE(($B$10:$B$14),1) which returns the
highest value, 200. What I am trying to do next is have data from the
corresponding row be returned. For example, I want MAR returned in the cell
next to the LARGE formula above. I tried to do this by turning on the R1C1
function, and inserting the formula into the reference, but it is taking t...Calculated Field in Extender
Is it possible to create a calculation in extender that uses fields from
different tables? Thanks
The fields have to be visible within the calculation window.
> Is it possible to create a calculation in extender that uses fields from
> different tables? Thanks
> Marisol Mortera
...reference to circular reference bug
I just discovered something that looks like a new excel bug:
to reproduce behaviour:
1. open a new workbook;
2. activate circular references;
3. enter those formulas:
B4 <- formula is =B5
B5 <- formula is =1+SE(B6;0;1)
B6 <- formala is =(B5=2)
B7 <- formula is =B5 (same as B4!!!)
(NB: SE() this is the standard IIF() function in the italian version
What's wrong: B4 and B7, will display different results even if they
contain the same formula. The result displayed depends on the position
of the cell conataining the formula: if it is on the left or above B5
the result...Showing user defined fields on a table in a form
Is there a way to program a form to show in a table in a subform the fields
the user selects? Or a way for a button to populate that table with
predefined fields or using Tabledef?
On Nov 21, 7:39 am, Akilah <Aki...@discussions.microsoft.com> wrote:
> Is there a way to program a form to show in a table in a subform the fields
> the user selects? Or a way for a button to populate that table with
> predefined fields or using Tabledef?
Can you provide a little more detail because I think the answer's
'yes' but it's hard to tell!
On Wed, 21 Nov 2007 07:39:02...Removing fields that are not system/business required
We need to do some extensive customization to our contracts form and I am
having difficulty removing fields that are not system or business required.
For example, I would like toremove the "bill to address" and "bill start"
and "bill end" dates. Theses fields are not required but apparently are
How can I find out what this dependency is? And is it possible to disable a
dependency once I know what it is?
Also, I would like to take some of the system required fields and
consolidate them in another section. Is this possible and if s...Mail Merge with Template Letter
Hi. I'm trying to set up Mail Merge in MS CRM 3.0 for some Contact records
and want to use the contact's Nickname when one exists. When I create a
blank letter or try to edit an existing letter template, the Nickname field
doesn't seem to be available. I know that custom fields aren't available,
but where are the other out-of-the-box fields besides the first, middle, and
last name and address fields? Am I missing something? Is it really this
Out of the box email merging is limited. Couple of ways get around it:
1. Connect Excel to the Filteredcontacts...Question for creating a league table
Hi I've began to setup a system in a tournament where when I update my
results sheet the table updates as well.
On here I want to know how I could get J2 to add up all the "L"s in
D2:I2. Would I use DCOUNTA for this and what would I use for database
joncurtis199's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=105
View this thread: http://www.excelforum.com/showthread.php?threadid=388952
=c...Code to make a Spinner button work with Filters on a Pivot Table
I create a lot of Pivot Tables with filter fields. Years ago I saw a demo on
this tool and loved it. I got the code and my computer died before I was
able to use it and my backup was a week old! Does anyone have this code?
Take a look on Debra Dalgleish's site
> I create a lot of Pivot Tables with filter fields. Years ago I saw a demo on
> this tool and loved it. I got the code and my computer died before I was
> able to use it and m...pivot table #5
I have a pivot table and would like to view and change my SQL and database
Are there any way to open it to debug and verify it?
I know that I can edit SQL from MS SQL if I use MS SQL to retreive data.
I could not figure to open the cub file to deit and debug.
Your inforamtion is great appreciated,
The free Pivot Play add-in, located at Debra Dalgleish's website, may help:
It allows you to view/edit the connection and SQL code for Pivot Tables that
use external data sources. It has many other features, too.
Does that help?
-----...Reference Site Apparel
I have a client with 16 stores in the UK who sell mans
suits, shirts and accessories.
They are very interested in RMS, but I am struggling at
the final hurdle. I need to find a RMS user in a similar
line with in excess of 10 stores.
Whilst we have several 10 store+ clients we don't have
any in clothing with this amount of stores using RMS
Is anyone or does anyone have a client who may be able to give some re-
assurances to my prospect by phone or via a visit.
...howto copy only newer OrderID data(and the other fields) from one table to another table
howto copy only newer OrderID data(and the other fields) from one
table to another table
So the new table is updated only with the new OrderID and the
OrderID's already copyied earlier are not also added everytime.
i use the append query i think and need certainly some criteria
Can somebody help me out, please?
The criteria you need (assuming OrderID is the key field) will be something
like this (use your table names):
= Not Exists (SELECT 'X' from [newTableName] where [newTableName].OrderID =
If...Sharepoint Linked Table
I just inherited an Access 2003 database which has a linked table to
Sharepoint (dbo_...) without any problem. When you view the actual table
from Sharepoint it only has 5 fields, but in Access 2003 have 12 fields. It
gets updated without any issue.
We are in the process of converting to Access 2007 and the linked table is
different from Access 2003. Most of the columns are dropped. Would anyone
know how I can keep the same exact column layout (# of columns) as in 2003?
This is necessary, because in the code, the linked table updates the local
table. Also, we must leave as is, beca...reference cells when looping
Using a loop like this
For Each tcell In Range("A4:A17").Cells
If tcell.Value = "Danny" Then
'Write a value into column 2 columns to the right
I want to write a value into the column 2 columns to the right of the
current column and on the same row but I am not sure how to reference
that cell in my code.
So if I find the value "Danny" (as above) in cell A8 - I want to write
the value "2" into cell A10.
Any help appreciated
tcell.offset(0,2).value = 2