Pivot tables lose of data fields when selecting
Having an issue with setting up pivot tables not to lose certain
fields if users de-selects some. For example I have muliple column of
a, b, c, d, e, f
The user de-selects d, e, f; The next time they want to see D, E, F.
The go back to the drop down menu and only see Show all, a, b, c. Is
there anyway I can always keep them so they can reslect the data? I
can go back into the wizard and add them back but that is time
consuming and tring to teach that to 30 users is a bit tricky.
...Sorting pivot table by specific field (column)
Hey guys (and girls),
Anyone know how to sort a pivot table by a specific field (not the
total sum of the fields)?
For instance, if I have 5 years of data 2002-6 and 20 countries. If I
make a pivot table of these I get 21 rows (the countries + total) and
6 columns for years (5 years of data + total). If I use the Field
Settings --> Advanced --> Sort by field the Pivot table (PT) will be
sorted by the sum of the different fields. What if I don't want this,
but rater want to sort it by for instance year 2003. How do I do that?
Anyone have a nice and clever solution? Much appreciated...can't print black
I have installed a lexmark 6570 fax wireless. It would not print any
doc's in black ink prints beautiful color pictures. I uninstalled and
reinstalled did not help. I figured is was the printer. Installed an HP
F4280 all in one, same problem.
can someone get me some advice!!!
twilltwo's Profile: http://forums.techarena.in/members/180192.htm
View this thread: http://forums.techarena.in/vista-help/1297957.htm
...outlook always default email application
I use Outlook 2003 for my callender and OE6 for email
Until a week ago, OE6 always remained the default email application unless I
installed a patch or updated Outlook, at which time it would set itself as
default. Fair enough.
Last week I upgraded by BIOS (not sure if this is relevant, but just so you
Now everytime I turn on Outlook, it becomes default mail programme.
In options/ general, OE6 tells me it is not the default.
Internet options lists Outlook as default
But in Outlook/Options/other the default mail,calender,contacts box is not
I change it all back and OE6 ...how i can change default file format Outlook uses to save message
I my saving message in my inbox using "File->Save As" menu.
"Save As.." dialog by default shows "Save As Type:" as "HTML".
How I can change default file format Outlook uses to save messages to as
"Outlook Message Format - Unicode" ??????
Rajkumar <Rajkumar@discussions.microsoft.com> wrote:
> I my saving message in my inbox using "File->Save As" menu.
> "Save As.." dialog by default shows "Save As Type:" as "HTML".
> How I can change default file format Outlook uses to save messages...can I get "step by step" on color seperating for commercial printi
This is kind of an extension on my previous message but I feel it would help
a lot more. Can someone give me a quick step by step on making a document
with text and photo into a press quality color seperated piece using PMS
colors and process black? Or maybe point me to a site that can give step by
step on that stuff?
...variable field width
I need to display client name and associated address information. There are
three rows of data which are taken from the contacts table.
The field boxes are all fixed in width, I want to make the width dependant
on the data length, and if the field data are short, the boxes would leave no
extra white space.
I may have several field boxes in a row, and I would like the boxes to go
right next to one another without spaces, so each field box position is
anchored to the end of the previous field box.
How would I implement this?
John D. wrote:
> I need to displ...Letter Writing Assistant selection based on Smart List Lookup
We had a great opportunity to use the letter writing assistance to send out a
notice to any vendor used within the last 6 months. Using the smartlist
lookup up we can see those vendors we have issued a check to based on Last
Check date, but the Letter Writing Assistant only allows you to select
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the ...Where can we get xml scheme for tuning setting of WM2003/WM5.0 PDA
We are working upon setting up a lot of WM2003/WM5.0 empowered mobile
devices according with company standards. As far as I know these settings are
tuned through xml file. Then this xml file has to be deployed
deployed/executed onto mobile device. My question is where xml scheme for
tuning such setting is published so we may assign necessary properties
Thank you in advance.
...Re: Can anyone help me with the IF function
I'm trying to help my wife with simplifying her scheduling o
employees. She uses 11 different time periods (1-11) some
are worth the same amount of hours others are more or less. I can us
seven functions to describe the period and the
value of hours it is worth, but when I consolidate the functions i
says the formula is invalid. I'm sure it can be
fixed by one of you excel gurus! Here are the functions
IF(B...How can I connfigure my outlook to access same profile accross mu.
How can I connfigure my outlook to access same profile accross multiple user
ids on a computer
Krishna <Krishna@discussions.microsoft.com> wrote:
> How can I connfigure my outlook to access same profile accross
> multiple user ids on a computer
You can't. Each user ID will have its own profile, sicne profile
information is kept in the registry in a user-specific area. However, you
can certainly reference the same message store within each profile. For POP
accounts, just put the PST somewhere in the Shared Documents hierarchy and
point to it within each profile.
B...Can administrator empty Deleted items in each mailbox
Is there any chance that administrator can delete all items in Deleted items
Are you talking in each user's mailbox or the deleted items available for
restore? What version of Exchange?
"Gasper" <NOSPAMgasper.firstname.lastname@example.org> wrote in message
> Is there any chance that administrator can delete all items in Deleted
Is it possible to delete Deleted items in each user mailbox on Exchange
...Active Directory Problem
Hopefully you can help me out a bit here. Long story short, we had a failure
last week that we were unable to recover Active Directory from. As such,
we've had to rebuild AD from scratch - now the domain name and all user
accounts are recreated and identical to the previous setup. However, I can
no longer access CRM.
I assume CRM 4.0 is authenticating on, not only AD membership, but based on
an AD GUID of some sort - which I can't replicate.
How can I get back in to re-load my users?
Did u check if the users were part of CRM groups created ...Alter View Defaults
It seems View defaults for "Arrange by" is set to "Show in groups" and
"reading pane" is set to "on".
How do I set the default for "arrange by"; "show in groups" to off and
"reading pane" to none. Seems I can only change one view at a time for each
See http://www.outlook-tips.net/howto/grouping.htm for the necessary steps.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engin...Can't Connect to Bank with Money 04 Trial Version
Does anyone know why I can't connect to my bank through
the trial version of Money 04? I use quicken at the
moment and after reading the negative reviews of the 04
update have decided to give money a try. The bank appears
on the list of participating institutions and indicates
that it is set up for direct connect/two way
communication. However, when I go through the Online
Services Manager it is listed under the heading "Banks
that have no Service". I would appreciate any answers!
...Default Auto delivery of incomming email...
I am an IT support technician who is searching for an answer that
one of our Account Managers has asked today. In a strange twist of
events, he would like his Outlook client to NOT automatically recieve
email, or at the very least, increase the time between automatic
deliveries. I have been combing the web for the past hour or so and
have been unable to find a solution to his request. IS there a
solution? My IT director is telling me that he is unaware of a setting
on Exchange Server 2003 that sets how often the server pushes messages
to the various accounts.
The cli...How can I see which lists a contact is a member of?
In Outlook 2007, is there a way to see which distribution lists a
contact is a member of? We have lots of lists. We want to be sure that
if we delete a contact in a group, instead of just removing it from
the group, that the contact doesn't exist in other groups as well.
Even a way to export to Excel would be ok, if there's nothing else.
The following macro in Outlook will list all the distribution lists
containing the name you enter into the dialog box in a Word document
Dim wdApp As Word.Application
Dim wdDoc As Word.Document
Dim myNameSp...can not delete in outlook
When I try to delete anything out of outlook i get the
The messaging interface have returned an unknown error.
If problem presists restart outlook
> When I try to delete anything out of outlook i get the
> following errror
> The messaging interface have returned an unknown error.
> If problem presists restart outlook
OL2000: Error Message: The Messaging Interface Has Returned an Unknown Error
...can I lock screen so only clicked links move slides in sldeshow
I have created question slides with Yes and No links to the next
corresponding slides eg if answer yes link goes to slide 2 if answer No goes
to slide 3 this happens during slide show presentation I want to be able to
lock the rest of the slide so that only a link click can progress to the next
slide because the process does not run in order if you just click anywhere on
the screen to progress the slides
On Jan 28, 5:19=A0pm, Workworry <Workwo...@discussions.microsoft.com>
> I have created =A0question slides with Yes and No links to the next
> corresponding ...Incorrect GL account defaulting on Billing Transaction Entry
There is no GL account associated with my Tax Schedule. when I use customer
having the same Tax Schedule I am getting 000-2300-00 (IL State Sales tax
payable) account assigned on the Billing Taransaction Entry Distribution
Screen on Project Account Module. Can anyone tell me why it is taking account
number eventhough I have not associated any GL to the tax schedule.
Thanks for help
It is probably looking into the Posting Accounts Setup table for the taxes
account (in the Sales group). In the demo company, this is set to the IL,
State Sales Tax Payable account.
These types of traces (...Can I import a .pdf file into publisher
I tried to copy and paste from InDesign and it did not work. Can you import
any type of file into publisher. Example: .pdf or .eps
No. Publisher is pretty much a stand all by itself program. If you can't
copy and paste into it, you're kind of sorely out of luck.
You can put pictures into a Pub file but you can't go back and edit the
individual parts of them, such as text.
MVP Microsoft [Publisher]
"Graphix grl" <Graphixgrl@discussions.microsoft.com> wrote in message
>I tried...Flag a value in a group...
Hi all, tia for any insight.
I have the following query that gives some totals for qty's in a releases
table, pulling and grouping information (part number, rev and desc) from a
details table. Table heirarchy is (one to manys) tblOrders ->
tblOrderDetails -> tblOrderReleases
Min(tblOrderReleases.fldDueDate) AS cfldFirstDue,
LEFT JOIN (tblOrderDetails
LE...CRM 1.2 SBS 2003 Can not install exchange email router
Logged on as domain admin throughout.
Installed CRM successfully, followed install instructions, did not install
to local host installed web to a hostheader of "companyweb" port 80.
during Exchange email router setup I get an error when specifying CRM
server and web - "one or more os the MS CRM servers you listed is invalid or
you do not have administrator priveleges on that server...."
server name: sbssrb01
If I go into IIS can not open CRM web get - http Error 403 - Forbidden:
Access is denied.
All services are on 1 server "sbssrv01&qu...Can I print one page landscape and the next page portrait on same.
I am trying to print the 3 pages of one worksheet and can not figure out how
to make page one print out as landscape, page 2 to print out as portrait and
page 3 to print out as landscape.
I'd record a macro when I printed page 1 as landscape, then page 2 as portrait
and then page 3 as landscape.
So I could just rerun that macro when I needed it.
> I am trying to print the 3 pages of one worksheet and can not figure out how
> to make page one print out as landscape, page 2 to print out as portrait and
> page 3 to print out as landscape.
Dave Pet...can you put photos in contacts?
Is there a way to put photos in my contacts/phonebook file? I'd like to
have pictures of some of the people in my phone book.
thanks for any help,
What version of Outlook? Prior to Outlook 2003, you can select the photo,
use the right click, select all, copy and then paste into Outlook. OUtlook
2003 offers a more intuitive method for this.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After furious head...