Is it possible in some way to fix the structure of a pivot table in excel or
even in Access so that I have a familiar layout even though the data may
vary from differences in the data. By implication, thefore to show empty
colums/rows somehow. This is very important to my situation.
I couldn't think of any way of changing the format of the
However to solve your problem, you could have your own
format in a different sheet (within the same file) and
link the pivet table using VLOOKUP( formula to get the
numbers to the right place.
You could use refresh data to upda...Outlook 2002 hangs on startup #2
This just started happening on Monday morning after
installing the latest office updates. Outlook opens but
hangs on the splash screen. Computer is a Dell GX-260 P4
1.7 GHz, 256 MB Ram and 60 GB HDD.
The only way to get Outlook to behave is to end it with
the Task Manager and re-open in Safe Mode. I went into
the Disabled items and nothing is listed there. No
evident errors in the event log.
Any help is much appreciated.
You may have a corrupted outcmd.dat file. This is the file that stores your
toolbar customizations, and when it becomes corrupted, Outlook can't us...I need help #2
Dear sir! My name is Pavel,I am from Ukraine.I need some cash to my
mother operations.Medics demand 4300$
I work in the mine,have high
education,but my work pay in the month consist near 200-300$.In my
city anybody can\'t help me! I don\'t now,real,if it\'s possible to ask
beg by You.My Visa card namber is 4149 6050 5023 6959 if you can transfer me
little amount 50-100$.Excuse me for my English.If you can help me, please
write to me, to my e-mail firstname.lastname@example.org Thanks,Paul
I created a pivot from a dataset. This was no problem at all. In a
later stadium I changed the recordset where the pivottable is based on.
For example i replaced all the records containing pete into mike in the
column <NAME>. When refreshing the pivot it now contains both mike and
pete. Pete is redundant, because i no longer exists. How do I get rid
Just drag the field out of the Pivot Table, then do a Refresh, then drag
it back again
"lennert" <email@example.com> wrote in message
news:1140180768.525075.3081...MS CRM 1.2 Vs. 1.0
Is there a web site (or a document) that says the differences between MS CRM
1.0 and 1.2?
If not, can anybody describe them in short?
Nope, and I doubt we'll see that list until it comes out. Everything has
been very hush hush, except to a select few non-MS people.............but
even to that, their promises don't have a good track history.
"SiEBEN Innovative Solutions" <firstname.lastname@example.org> wrote in message
> Is there a web site (or a document) that says the differenc...Does anyone know the PivotTable Refresh Event? #2
Thank you Debra it worked fine for me
JohnD'Elia's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1531
View this thread: http://www.excelforum.com/showthread.php?threadid=26930
You're welcome. Thanks for letting me know that it worked.
> Thank you Debra it worked fine for me.
Excel FAQ, Tips & Book List
...Mailbox Issue #2
For some reason with one mailbox on my network I am unable to log into
outlook. I'm able to log on to the network with no problem. No matter what
I put into the password field for outlook it will not log me on. The
password is correct. Its very weird. this just started happening.
What error message are you getting? Can you login using OWA?
- Ibrahim Kazi
"George Schneider" <email@example.com> wrote in message
> For some reason with one mailbox on my network I am unable to log into
> o...Calculating(Processors(2)): %
I am running the code below in a .xlsm '07 spreadsheet. The problem I'm
having is the code runs painfully slow and I can't figure out why. As soon
as it starts my CPU usage spikes up to 52%, 51% of which is EXCEL.EXE. I
also get "Calculating(Processors(2)): %" in my status bar constantly
calculating "something" and showing me percentages. I tested this code using
1000 rows of data and it took ~8 mins, 2000 rows took ~15 mins, and 4000 rows
took ~28 mins. Each row of data has information in columns A-Q. What is
causing this latency? All the ...(APPZ) Ashampoo.Magical.Snap.2.v2.51.incl.Keygen.WinAll-LAXiTY
=ybegin part=1 line=128 size=258 name=Ashampoo.Magical.Snap.2.v2.51.incl.Keygen.WinAll-LAXiTY.sfv
=ypart begin=1 end=258
=yend size=258 part=1 pcrc32=a59b918d
=ybegin part=1 line=128 size=1312 name=Ashampoo.Magical.Snap.2.v2.51.incl.Keygen.WinAll-LAXiTY.par2
=ypart begin=1 end=1312
zk|\*zu~�*******�]LHtZ�&�0=}�a���̨�:...How do I add new data to a pivottable/chart?
I have a spreadsheet that I add new data to weekly. Is there a way to have
the pivottables/charts refresh to include this data without recreating them?
If I try to do extend the range of cells used to create them originally, I am
unable to group dates (which I need to do) on the chart because of blank
You can use a dynamic range as the pivot table source, and it will
automatically expand as rows or columns are added. There are
When you refresh the pivot table, all the new data will be included.
Brian Lee wr...PivotTable data...
How do I use more than one Summary function for a PivotTable data field?
In the Pivot Wizard, add another copy of the field to the data area
Double-click on the new field, and under 'Summarize by', choose one of
> How do I use more than one Summary function for a PivotTable data field?
Excel FAQ, Tips & Book List
We do have four companies. When I am generating the FRx reports for companies
A & B from workstation # 1, I am getting the following error message:
Error 91: Checking OFSI Table Is Current Status for:frl_acct_code
Error 91: Object variable not set. This is possibly due to a version
mismatch between an FRx program and FRx database. You may need to re-install
I can generate the FRx report from workstation #1 for companies C & D.
The situation from workstation # 2 is reverse, I can generate the FRx
reports for companies A & B but with companies C & D I am getting th...Chart Templates #2
Does anybody know where the UserDefined Charts are stored inside Excel 2003,
and also could they have there default location changed.
I believe the file is called "xlusrgal.xls". You will need to have at least
one user-defined chart created to obtain this file.
> Does anybody know where the UserDefined Charts are stored inside Excel 2003,
> and also could they have there default location changed.
...2 XL versions on one pc?
I have XL-XP installed and I need XL97. Do I need to uninstall XL-XP before
installing XL97 or I can have them both?
Thanks in advance.
See the post by me and many responses by MVP'S on Feb 7 2004 in this
Yes, you can have them both, but you will need to un-install XP first.
Then install 97.
Then re-install XP.
When installimng, be sure to specify different folders for 97 and 2002.
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email addr...Importing Tables #2
If I had access how would I do it?
under v2002 pro, open database model stencil, select database, select
reengineer, follow prompts.
"Jean" <firstname.lastname@example.org> wrote in message
> If I had access how would I do it?
I am so new at this. I go to File, Stencil, Open Stencil,
I end up in a Solutions folder, then I go into Database
and pick Entity Relationship (US units).vss? I do not see
>under v2002 pro, open database model stencil, select
database,...owner draw list box #2
I want to have a list box with check box and text displayed.
My text should behave a link.
For that i derived a class from CCheckListBox and able to draw check box
along with text underlined which now looks like a link.
But the problem is when is click on the link, the text is overwriting check
Can anyone help in this?
Sounds like you are not accounting for the space the checkboxes take when
you are drawing out your text. You should move your text to the right some
to give the checkboxes room to draw.
This one doesn't have checkboxes, but perhaps some of the c...How Do I insert the keystrokes SHIFTF3 into a cell? #2
I am trying paste data from excel into another software program, In order to
speed up data entry. In orde for it to work correctly I was wondering how I
would tpye/insert the keystrokes ShiftF3 into a cell so that we I copy it
over to the other software program it performs the function clear
field(ShiftF3 performs the clear field command in the other software
Or does anyone have any ideas how I would get around this issue?
hi, i apply background on my sheet by format/sheet/background. but it doesn't
appear when i print the page.
How can I print a background behind my datas? can anyone help please?
The sheet>background is for display on sheet only. Does not print.
Please have a look at the links provided by Bob Phillips.
These lead to methods for creating printable background watermarks.
Gord Dibben Excel MVP
On Sun, 31 Oct 2004 14:11:01 -0800, "mansure"
>hi, i apply backgroun...Unbound Combo Refresh
I have an unbound combo on a form that is summing a value from a subform.
(=sum([project payments]) I need it to update as I change from one record to
the next in the main form. The mainform and subform are linked by project #.
State of Arkansas
me.unboundcombo.requery in the form current event would be my initial
> I have an unbound combo on a form that is summing a value from a subform.
> (=sum([project payments]) I need it to update as I change from one record to
&g...How do I make 1 and 1/2 cups look like 1 1/2?
I do not want it to look like eleven. How do I make the 1/2 part look better
to create one and one half cups?
Mary Sauer MSFT MVP
"Shelby" <Shelby@discussions.microsoft.com> wrote in message
>I do not want it to look like eleven. How do I make the 1/2 part look better
> to create one and one half cups?
> I do not want it to look like eleven. How do I make the 1/2 part look be...Comment #2
Can you copy a picture into a comment?
Click Comment in the Format Menu
Click on the Colors and lines tab
On the drop down in the color tab click Fill effects
in the fill effects box click Pictures/Select Picture
If you see hash marks around the comment box right click the has
Hope this helps
keithl816's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2128
View this thread: http://www.excelforum.com/showthread.php?threadid=49804
...If statement help #2
I have a problem building a formula to do the following; I have a give
number which I want to split up to allocated levels.
Cell1 allocated the first 4000
Cell 2 the next 16000
Cell 3 the next 50000
Cell 4 the balance
However, if the number is only 2000 I wish that cells 2, 3 & 4 record
I have been using IF statements however I am not sure this is correct
Message posted from http://www.ExcelForum.com
There are several ways to do this, so there is no single correct way. IFs
should be perfectly ok. I'd do this:
=MIN(A1-4...Inverting Text #2
I have a simple question with Microsoft Excel 2000, if
anyone could e-mail me the answer to:
it would be much appreciated.
How do you invert text (turn in upside down)? I'm trying
to print something but have it come out upside down, and
help would be much appreciated.
Thanks a bunch,
If its not possible, let me know as well.
If its easier, just respond here, instead of sending an e-
Thank you very much in advance,
You can use the camera tool and insert a picture, then rotate the picture.
It's under vie...mailbox size limits #2
We currently do not have any size limits and have a few users with huge
I want to know if I setup the mailbox sixe limit's does exchange have a
ceiling on it.. I tried to set the limit for like 4 gig but it wouldn't let
Please let me know.
Well via the GUI its 2 GB.
But you can do this to go higher:
"Stup88" <Stup88@discussions.microsoft.com> wrote in message
> We currently do not have any size limits and have a ...Printing from Outlook #2
We use Windows 2000 and Microsoft Office 2002.
One person in our network (Windows NT) cannot print from the internet or
from Outlook if the message comes in in HTML. He can copy things from the
net, paste them to Word and then print. He can convert a message from HTML
to plain text and it will print. Is there a setting somewhere that keeps
HTML content from going to a printer? Any suggestions would be appreciated
as our network guy just says it's a problem with the building -- but it
hasn't always had this problem, and nobody else has the problem.
can this person print fr...