I have a Pivot table and attached Pivot chart (all good so far). However,
there are three columns (drop column details here) which are the two columns
of data and a grand total column (showing the average of my two data columns)
When I turn it into a pivot chart it does not display the grand total column
as well (is there a way to do this). I have tried to go into the chart
options but these are locked.
I can copy and paste the results but this is a bit clumsy.
Any suggestions - any help greatly appreciated
PS using excel 2003
...password help #2
I have to access a file that hasn't been opened in 3
years. It is password protected and I have the password
written down. However when I type in the password it is
not accepted. I have tried the password in every
combination of upper & lower case letters but it still
won't let me in. Could upgrading my operating system and
version of Excel affect the password? I think when the
file was created I was running Win 98 and Office 97. Now
I have Win XP and Office 2002. I don't have a hard copy
of the info in this file so I'm kind of desprate. Any
help would be appr...Ma8QBaYXf0 #2
Is this a secret??
...A question about thread,please help me #2
My program environment is .net2005.The partial code is shown as below:
void CfinalView::OnRButtonDblClk(UINT nFlags, CPoint point)
Does anyone have a Demo db that would work for a Vitamin shop. I am doing a
demo in an hour and a half, and could use a hand. Sorry to ask for it here,
just kinda got sprung on me.
...Excel Headers #2
Can I set up more than one header / footer in excel.
I don't want the header to appear on all pages, just a few select ones. And
on some pages, I want different headers, or footers.
Posted via a free Usenet account from http://www.teranews.com
Each sheet in the workbook can have it's own individual header/footer.
> Can I set up more than one header / footer in excel.
> I don't want the header to appear on all pages, just a few select ones. And
> on some pages, I want different headers, or footers.
&...how convert CRichEdit20A version to CRichEdit20W in CRichEditView
I need to use CRichEdit20W version in CRichEditView since i am dealing with
double byte characters.
what are the things i have to do?
is it safe to use CRichEdit member functions(GetTextRange(),
GetSel(),CharFromPos(), LineIndex()) with double byte characters?
When you say, "double byte", do you mean "double byte" (e.g. Japanese,
Chinese, Korean double-byte character sets) or do you mean "Unicode" (i.e.
In fact, it probably doesn't matter much, because even 20A does Unicode and
I'm sure both would do "double byte" cha...Working with dates in Excel #2
I have two columns with date (an effective and expiration date), for a pivot table I need to combine these two into one statement "5/1/2003 to 5/1/2004" I created a formula, example (=A1 & " to " & b1), the result is "37742 to 38108
How do I get the # to show as a date
I know that if you add an ' in front of a date it shows as text. I have several thousand records and would need to add it to each field. A way to add the ' to all the records would also be an acceptable way for me to go. I just don't want to have to input the ' in each fiel...Cell formatting
I am using a formula to copy cells from one sheet to another.
Everything is ok except the date column.
The when that cell is "" or -0- it shows 1/0/1900
How can I change this to "-" or blank?
In article <email@example.com>,
"seve" <firstname.lastname@example.org> wrote:
> I am using a formula to copy cells from one sheet to another.
> Everything is ok except the date column.
> The when that cell is "" or -0- it shows 1/0...How to get rid of the gridline? #2
slamm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1501
View this thread: http://www.excelforum.com/showthread.php?threadid=26636
...2 level group per report
I have a report that needs to be grouped in 2 level, per country and per
My problem is I need to see data on the first page of the first level group
and the first page of the second level group (province).
I have tried many combination of forcing new page on both level but I cannot
keep the group header of the province with the data when the province change,
meaning I see data in Canada, Alberta and on the same page, I will see the
group header of the next province when it is time to change on the same page.
which I cannot see
If I force new page on the p...Pivot Table Calculated Item #2
The Calculated Item selection is greyed out on the Pivot Tables/Formula drop
down menu. I have my cursor in a field that I want to calculate. What am I
If your pivot table is based on OLAP source data, you can't create
formulas. Could that be the problem?
> The Calculated Item selection is greyed out on the Pivot Tables/Formula drop
> down menu. I have my cursor in a field that I want to calculate. What am I
> doing wrong?
Excel FAQ, Tips & Book List
...Why won't my 2 publication pages switch to 2-pg view as asked?
This is a brand new publication. It only has two pages to it. There is
hardly any content and NO web links.
But when I use the VIEW drop down menu and click that very first option
saying "Two-page spread", Microsoft Publisher does absolutely NOTHING!
No, not in print view ... i'm saying "nothing". Yes, I've restarted my
computer... all that.
Also, in the master page view many of the options are totally greyed-out.
Why doesn't microsoft just fix its software instead of adding new inefficient
You must have three or more pages to see a two-page ...Filter Mode #2
I have been sent a large spreadsheet. The problem is that when I fillter
the data instead of the number of rows which have been filltered out being
displayed on the left hand side of the status bar the words "filter mode"
appear. How do I get rid of the "filter mode" so that status bar shows the
number of records filtered?
...why does the 0 dissapear when i start a telephone no with 0
I am keeping a list of account numbers and sort codes, but every time i type
a number beginning with a 0 it is auto removed!!
Before typing the number beginning with zero, convert that cell format to
text (Format--> Cells-->Number--> select Text in the list) otherwise begin
with ' (single quote) and then type the number ('012345).
Hope this will clear your doubt.
> I am keeping a list of account numbers and sort codes, but every time i type
> a number beginning with a 0 it is auto removed!!
Format your cell as 000...Querying 2 databases with one query string
I can use the following code to create a conection string:
sConnect = "Provider=SQLOLEDB;" & _
"Data Source=Ben;" & _
"Initial Catalog=Northwind;" & _
...then execute a SQL statement to return the query results to my workbook.
Is it possible though, to store the results of a query that joins 2 tables
contaned in separate SQL databases?
...Change 2 names in one cell to one name in 2 cells
Is there a way that if there are two names in one cell (a1), i.e.;
Johnson--Jackson, that they can be changed to be listed in two
different cells, such as, Johnson in cell b1 and Jackson in cell b2. I
have a very long list of names and I do not want to go through the list
and type every thing in again.
Thanks for any assistance you can give me. WAB
Use the Data/Text to Columns wizard.
In article <email@example.com>,
"wab" <firstname.lastname@example.org> wrote:
> Is there a way that if there are two names in one cell (a1), i.e.;
> Johnson-...Setting up email #2
Is there a best practice used for setting up the mailbox in Outlook. I want
to use my hotmail or gmail accounts and manage them through Outlook 2007.
What is the best way to do this?
Check Hotmail and Gmail Help files for information. Assistance after =
you have read and used the free tutorials is gladly supplied. =20
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, UserGreg asked:
| Is there a best practice used for sett...CRIchEditView
I created new SDI application in MFC.
class CTestView : public CView
class CTestView : public CRichEditView
and in message map to:
it compiled ok, but when i try to run it hangs. WHy ?
I want to have CRichEditView instead of CView class.
>I created new SDI application in MFC.
>class CTestView : public CView
>class CTestView : public CRichEditView
>and in message map to:
>BEGIN_MESSAGE_MAP(CTestView, ...Return 0 if cell has data, of copy if it doesn't
This was what I needed, Thank you! But now it leads me to the next
step.....(probably would be easier to just enter the $0 myself)
Here is what I need: the 'simple' spreadsheet is for refunds we owe
clients. Column D is refund owing, Column G is date mailed, H represents $0
balance, which is the formula I was just given. Now, how do I fix the
formula to actually display the amount of refund due from Column D IF column
G isn't populated, but if it does have a date mailed then H would display $0?
I should have asked this in the first place. Sorry.
"Joe Us...Rollup 2 #2
Can you see somewhere in CRM if you have installed Rollup 2 or not?
I have been on Help---About MS CRM without seeing it.
On Feb 19, 7:04=A0am, Martin <Mar...@discussions.microsoft.com> wrote:
> Can you see somewhere in CRM if you have installed Rollup 2 or not?
> I have been on Help---About MS CRM without seeing it.
You'll have to go the MS site to find out what the version of CRM will
be after the rollup is installed (I'm not sure if you're using 3.0 or
4.0). Then you can go to the about MS CRM menu to see if the version
Hope that helps, goo...Hyperlink warning #2
Some computers with Office 2003 with a hyperlink embedded in an Excel
workbook will not follow the link even to a local file on the hard drive
without a warning message.
I have followed the instructions on the
http://support.microsoft.com/?kbid=829072 link, trying both registry entries
for Common Security and Excel Security. I have also tried the other
suggestions. None work.
I support an application used by clinicians and researchers which contains
frequently used links to sound (.wav) files. This application is made
unusable by the repeated warning messages.
Any new answers plea...OUTLOOK 98 #2
The "Stationery and Fonts" section found under "Tools", "Options", "Mail
Format" in Outlook 98 has the "Stationery Picker" button greyed out. This
obviously prevents selecting the stationery to use as the default for email
messages. Has anyone had this problem, or does someone know how to correct
This problem usually occurs because of a permissions
issue. If you're logging onto an Exchange server at work,
chances are your admin has scaled you back. If it is at
home or on a system...Confidentiality Notice #2
How do i configure Exchange 2003 to add a Confidentiality Notice at the
bottom of all outgoing emails??
Can this be done without using Visual Basic?
...Vanishing emails #2
When downloading messages from a mailbox hosted by my ISP,
on occasions Outlook indicates that it is downloading 1 or
more messages, but they vanish (do not end up in the inbox
Any thoughts gratefully appreciated.
rules moving them somewhere? junk mail filter or antivirus filter catching
them before outlook gets them?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.c...