Chip Pearson- you're web page is down
I am getting a 404 error on Cpearson.com
cpearson.com/excel.html works though
The page loads fine for me.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"scott" <email@example.com> wrote in message
>I am getting a 404 error on Cpearson.com
> cpearson.com/excel.html works though
works fine for me too
Rob van Gelder - http://www.vangelder.co.nz/excel
"Chip Pearson" <firstname.lastname@example.org> wrote in message
news:%23YvgfrLBFHA.3492@TK2MSFTNGP...I'm stuck on a circular reference
A spreadsheet has two columns, month to date and year to date.
Is there some way without using another column, to be able to place a new
value in the MTD column and have it add it into the YTD column to give a
current YTD value?
Change the 3 to 5 then:
There are many rows and many sheets to update; I'm looking for an easy way
to copy last month's workbook and just change the MTD figure and have it
update the YTD automatically without causing a circular reference.
You will not be able to do ...Office Test Drive re-installs over Office 10.1.5
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Content-type: text/plain; charset="US-ASCII"
Hi . . . this happened in reverse order from any of the other Test Drive /
full install postings I've found . . . In attempting to restore some
Apple-installed software that was corrupted in a hard drive crash on my 12"
Powerbook G4 (867mhz, os10.2.8), Office v.X Test Drive was re-installed.
Although all of my user data is still intact,...security update KB972696 will not install
Windows XP home, dial-up service, cannot get kb792696 to install. I get
error code 0x8050855C. I cannot find this code doing a search. MS support
is worthless so am asking for help here. Ran Malicious Software Removal
Tool, found nothing. I use MS Security Essentials, have one red icon showing
no protection, another green showing full protection. What?????????
Double-check that KB number & error code, please.
Is this a sudden, new problem?
Are you running WinXP SP2 or SP3?
What anti-virus application or security suite is installed and is your
subsc...Problem with re-installing Office Home and Student 2007
I am trying to re-install Office 2007 after a hard drive failure. When I run
the setup programme I get the message "Microsoft Setup Bootstrapper has
stopped working". Can anyone help me with a way to overcome this?
"makkih" <email@example.com> wrote in message
> I am trying to re-install Office 2007 after a hard drive failure. When I
> the setup programme I get the message "Microsoft Setup Bootstrapper has
> stopped working". Can anyone help me with...Server 2003 update problem
This server is running server 2003 sp2, hasn't been updated in quite a while,
was a terminal server but not any more. When I run windows update it wants to
install a new version of update. It fails with error 0x8024D007. I tried a
few troubleshooting steps I found online without success. One of these was to
unregister and re-register wuaueng.dll. It will not re-register, gives the
message "dllregisterserver in wuaueng.dll failed. Return code was
0x80070514". I renamed this dll and it was recreated but still the same
error. I expanded the dll from the 2003 disk to th...2007 Microsoft Office suite Service Pack 2 (sp2), update error
Every time I try to update Office 2007 Ultimate with the service pack 2, I
receive the following error: "package error installation". On the Update
History, the code error is: 0x80246002. I'm running Windows XP SP3. I
downloaded the SP2 and tried to install it manually with no avail.
"M. Quintana" <M. Quintana@discussions.microsoft.com> wrote in message
> Every time I try to update Office 2007 Ultimate with the service pack 2, I
> receive the following error: "p...Re: Using Text Styles
Front page will not have a Next Edition. AFAIK it is dead.
> Ed Bennett wrote:
> > Ron Hagley wrote:
> >> I have a document with Headings on one line followed by a linespace
> >> then on a new line a subheading followed by (on the same line ) a
> >> description
> >> I wish to use TEXT STYLES as this pattern repeats many times, I have
> >> no problem seting up the styles for the headings, but when I do the
> >> same for the SUBHEADINGS the text style is applied to the WHOLE line
> >> including the description...Re-mortgage
I have been using a loan account to track my mortgage payments. Recently I
have re-mortgaged with another provider for a higher amount and I've set
another loan account up. I want to be transfer the money into the old account
to close it off and transfer the balance into the current account.
Money doesn't seem to want to transfer money between loans. So how do I show
that the loan is closed and principle paid off? I tried creating a catagory
but then money reports a massive outgoing aganist it distorting all the
Very sadly, Money makes it difficult to just transfer M...Scroll window -update the buffer
I want to change the scroll window line items fields value which
are not currently focused (selected line).
Ex: If I enter the 5 in line3, the corresponding field in line 1 and 2
should be change to 5.
Is it possible without re fill the window after update the table?
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> I want to change the scroll window line items fie...How to Update GP Client?
I have updated GP application on one client machine. If i want to update or
incorporate new changes to each
client machines then what should i do?
Each of the client machines need to have the updated application installed.
> I have updated GP application on one client machine. If i want to update or
> incorporate new changes to each
> client machines then what should i do?
"Leslie Vail" wrote:
> Each of the client machines need to have the updated application installed.
> "Nupur" wrote:
> > I have updated GP...Auto-updater problem if Office not on boot partition
Operating System: Mac OS X 10.5 (Leopard)
I prefer to have my applications installed on a different volume than my boot partition. Office won't let me choose a different folder/partition during the installation. But, once it's installed, I can move it to my "apps" partition and it runs fine.
However, the auto-update just launched and, I guess, because the applications are not on the boot partition, the update just hangs when it gets to the "Destination Select" step. It never enables any of the partitions (volumes) on my computer. All...update fails
Every time I try to install KB979906 a MS update for net framework 1.1 sp1
it gets half installed then I hear the HD growl and it fails to install.
Keeps coming back as a needed update.
Should have mentioned this: running XPpro sp3 with manual update install.
This update comes back almost immediately as "updates are ready for your
"shakey" <NOONE@NOWHERE.NET> wrote in message
> Every time I try to install KB979906 a MS update for net framework 1.1 sp1
> i...Updating a cell?
Here is what I need to do:
For each cell in a worksheet I have a dropdown list of minutes whic
can be picked from. I then want to go back to a specific cell and pic
another value which will be added to the value that was originall
entered for that cell. So for cell A1 say, I first select 10 and the
later go back to cell A1 and select 20 - I want the cells new value t
be 30. Is there anyway I can do this
Message posted from http://www.ExcelForum.com
this could only be done with VBA using an event procedure. See
for an example to do this
...Multiple Muliselect Listbox form update
Hello, I am trying to work though getting multiple muliselect listboxes to
work. Got the first one to work but I can't get the second one to work.
They are going to be cascading to filter a subform.
my code that doesn't work is:
Private Sub BarType_Click()
Dim MyDB2 As Database
Dim qdf2 As QueryDef
Dim i2 As Integer, strSQL2 As String
Dim strwhere2 As String, strIN2 As String
Dim ctl2 As Control
Dim frm2 As Form
Dim varItm2 As Variant
sDocName2 = "BarInquiry SearchBarTypes"
Set MyDB2 = CurrentDb()
Set frm2 = Forms!BarInquiry
Set ctl2 = frm2!BarType
...Try critical patch from the MS Corporation
Content-Type: multipart/related; boundary="sdgynqqiirijqhg";
Content-Type: multipart/alternative; boundary="ehniohmateprxutp"
this is the latest version of security update, the
"October 2002, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to protect your computer.
This update includes th...update Quote Product entity with my own price value
I have two queries regarding using Pre or Post Update Plugin.
1. To update Quote product entity with my own price value and please
suggest me whether to use Pre or Post Update Plugin.
2. To update account using Post Update Plugin while updating the
...Problem Updating Money 2000 to Broker Statement Persists
I have downloaded activity reported by my broker to Money
2000 and am on the page "Review Investment Activity". The
page says to click "Next" to update Money to the
statement, but when I do the page freezes for about 15
seconds and stays the same. Nothing happens. Why? What can
be done to update Money 2000 to the statement?
I was advised to close Money, delete the browser temporary
files and then open Money with Start, Run and "msmoney -s"
(omitting the parentheses), which I did. This did not
solve the problem.
Any help would be greatly appreciated.
...Update one Worksheet from Another
I want to be able to update a worksheet by looking up data from another
worksheet. in other words;
If Servername in Worksheet A column A equals Servername in Worksheet B
Column C then copy serial number from Worksheet B column D to Worksheet
A column D.
Thanks in advance for any help.
you can use the VLOOKUP function to achieve this.
in Worksheet A column D type
this will return the information from column D of Worksheet B where there is
an exact match between the data in column A of the current sheet and column
C of worksheet B....RE: Converting from existing Mailt to Outlook
My internet connection is through Cox Cable and is continual access; I am a
Yahoo Plus subscriber and receive virtually all of my email thru yahoo, and
my permenant address is a yahoo address.
I own MSOffice Enterprise 2007 which, of course includes Outlook 2007; I
want to set Outlook up as my communications program for home, office, and
mobile (I have 6.1 on my mobile.).
Program Outlook 2007 to be my email server; keep my current yahoo email
address as primary; connect outlook 2007 through my esisting cable
connection; and import my existing contacts files into outlook for usage a...Apply a Recipient Update Policy to mail enabled groups
I would like to use a RUP to change the mail address of certain mail enabled
groups. So far I've been unsuccesful. Any hints or tips are welcome since
information on this subject is hard to find. I'm using Exchange 2000.
This article relates to POP3 users, but it should point you in the right
Jeff Guillet, MCSE
> I would like to use a RUP to change the mai...Update GAL exchange 5.5
How to update Global Address list in Exchange server 5.5 with service pack
Not sure what you mean by update GAL?
"Shaikh" <firstname.lastname@example.org> wrote in message
> How to update Global Address list in Exchange server 5.5 with service pack
I mean , i want to update my GAL so that old e-mail address which is
deleated will remove form GAL.
the reson is i am getting junk mails to old E-mail box's which r removed
and system ...Why do series names on charts disappear when re-opening excel?
I have set up some bar charts in excel to display the series names and values
of each series. However, when I close the application and re-open it, the
series names are gone. I have checked the chart options, and the series name
box is still checked. How do I fix this? Thanks
...M$2004 uses estimated bill amount, not downloaded amount
I just upgraded from M$2002 to M$2004, and now when I
download my statements and match them to my Bills and
Deposits, it records the amount in the estimate, rather
than the downloaded amount. Is there an option for
configuring which AMOUNT to use?
What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
As you may know, newsgroups have existed for many years now; however, the
traffic in the Microsoft newsgroups has been steadily decreasing for the
past several years while customers and participants are increasingly finding
solutions in the forums on Microsoft properties and third party sites. This
move will unify the customer experience, centralize content, make it easier
for active contributors to retain their influence, miti...