Using iterations to calculate circular references.
I am working with data that requires using circular references in some
calculations. I checked the "iterations" box to allow for these calculations
to work, and Ecxel seems to be calculating everything correctly. The problem
is that after I close the workbook, when I later reopen it to continue
working, all the cells that are a part of the circular reference display the
#VALUE! error. I can fix this by deleting one cell that is part of the loop
and then undoing that command, or by copying the formula from a cell,
deleting it, and pasting it back into the same cell. I have to d...Update Manager
Everytime I boot up my PC a small window pops up entitled "UPDATE MANAGER".
It shows two progress bars, but nothing ever happens. Why is this window
popping up every tiem I turn on the computer and how do I get it to stop?
It never used to do this, it just statred lately. Thankyou.
Because you installed something which features an update manager
"Omaha Tony" <OmahaTony@discussions.microsoft.com> wrote in message
> Everytime I boot up my PC a small window pops up entitled "UP...Outlook 2000 doesn't respond after downloading MS update!!
Luckily, my Outlook Express seems to work, but my Outlook 2000 will open,
but if I click on a message or do Anything, it FREEZES.
HELP!! I rely on calendar functions, other things.
HOW could MS allow an update that screws up their own programs?
I did restore - to no avail. I lent CD to someone, so can't do "repair."
(Trying to get a hold of friend)
Please help! I'm in process of job hunt & really need Outlook to
Did you recently apply SP3 for Office/Outlook 2000 and is Outlook 2000
configured in Internet Mail Only mode? If yes, you...Publisher file made in Publisher 2007 won't open in 2007
I produced an 8.5 x 11 brochure two days ago in Publisher 2007. I was able
to save, resave and reopen the file many times during the day. When I tried
to open the file today, I get the "Publisher cannot open the file" error
message. I've tried to open the file on two different machines with
Publisher 2007 and get the error message both time. One has XP Pro, the
other has Visa Home Basic. It's a 1.6 meg file. I have a smaller publisher
file of a bumper sticker (40 kb) which was made a couple of weeks ago which
opens with no problem.
This is the second time I ha...Microsoft Money 2007 Deluxe Canadian version?
I have been looking for Microsoft Money 2007 Deluxe Canadian version and I
cannot find it. Where can I get one?
There isn't one. See http://money.mvps.org/faq/article/422.aspx
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"masai" <email@example.com> wrote in message
>I have been looking for Microsoft Money 2007 Deluxe Canadian version and I
>ca...does vista installed on virtual machine 2007 get wsus updates ?
It is searching for updates but it is not finding anything and saying
that Windows is up to date. I have set the updates to install from the
wsus server and assigned the updates to the same Vista virtual machine
aconti's Profile: http://forums.techarena.in/members/73272.htm
View this thread: http://forums.techarena.in/active-directory/1290161.htm
If the machine is getting the correct GPO for the WSUS settings, check with
rsop...Office 2007 trial is very slow. Is this because it's a trial
I just started using the trial version of Office 2007. It takes forever for
it to open on my computer but Office 2003 opens just fine. Is this just
because it's a trial or is it naturally slow because of the additional
It's likely due to the expanded feature set and increased hardware
requirement over Office 2003.
> I just started using the trial version of Office 2007. It takes forever for
> it to open on my computer but Office 2003 opens just fine. Is this just
> because it's a trial or is it naturally slow because of the ad...Can't edit print styles in Outlook 2007
Weekly calendar view to print - Define print Styles - Edit "CANNOT DISPLAY
THE DIALOG BOX"
I'm using trial version - shouldn't be the case????
I'm having the same problem where I cant edit the print syles ... please let me know what ou find out.
I think being able adjust the format and print the calendar is important, as I usually print my calendar.
EggHeadCafe.com - .NET Developer Portal of Choice
This is an Excel newsgroup. I would suggest posting this to an Outlook one
Microsoft MVP - Excel
hi all and thanks for the support.
i'm facing a problem with test.outlookwebservices.
notice that oulook side everything seems to be pretty good: the
autodiscovery and auto-configuration of the account succeedes, the test email
autoconfiguration suceedes too.
when i launch the test, once it suceedes for certain services and after a
while it fails for those services and suceedes for other.
look the prints:
here are failing the RPC tests
Message : [EXCH] The UM is configured for this user in the AutoDiscover
response received from https://mytest-EXC1.
myt...Problem with systemstate backup with DPM 2010
We running DPM 2010RC on a Windows 2008 R2
The Protected computer is:
Microsoft(R) Windows(R) Server 2003, Standard Edition
5.2.3790 Service Pack 2 Build 3790
When we installed the DPM agent the first backup of system state was
successfully, so we have one restore point. But further backups in failing,
the system state backup is in status “replica is inconsistent” and when I
running a consistent check the job failing.
In the error in DPM is:
The replica of System Protection Computer\System Protection on
sea0700smon1.xxxx.local is inconsistent with the protected data so...Fewer normal template problems with Word 2000 or 2002?
I have enjoyed some things about Word 2007, but I keep having problems
with macros and templates. I am wondering if (a) macros increase the
likelihood of corrupting the normal template in 2007, or (b) if the
older versions of Word had as many template problems. I have used Word
in 2000, with Office 2003, and now with Office 2007 and I don't ever
recall having as many problems as I've had with 2007.
What I'm thinking is that if it is simply a macro problem causing
corruption, I would simply use 2007 without the macros (they're nice
but I can live without them). On the...Font problem
It seems that the Cambria Math font has recently acquired an extremely large
Ascent and Descent. Has it perhaps always been that way and I've never
noticed it before, or is it something recent, perhaps a Vista thing? Try the
following code for example. For Arial and Times New Roman (and virtually all
other fonts) I am getting pretty much exactly what I would expect (a
TextHeight that is a bit larger than the point size) but for Cambria Math I
am getting an extremely large TextHeight (I get exactly the same results
using GDI32 methods). At this end (on my Vista Business laptop...Office 2007 SP2
Has anyone else lost the little check box which is usually found next to
each task in the task list in Outlook today? I'm assuming it's a bug?
"Carmen Gauvin-O'Donnell" <firstname.lastname@example.org> wrote in message
> Has anyone else lost the little check box which is usually found next to
> each task in the task list in Outlook today? I'm assuming it's a bug?
Nope - still there...
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level...08 Mac Office activation problems
Operating System: Mac OS X 10.5 (Leopard)
Just found an article posted by michellec and I am faced with exactly the same problem - on 'activation' of the product, none of the 3 product keys seem to be correct, hence activation is unsuccessful!! Have received some help emails (and thanks Diana yours had the microsoft help number that has been good, despite the fact they can't help me and tell me I must get in touch with Digital River) but seems that what I need is another product key, and now that I'm asking for that since about 10 days, I don't get any reply ...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the
number of the column I want to chart (these numbers are listed as labels in
I can't figure out how to translate the number in S4 into the corresponding
column letter. For example, if S4 contains "3", the chart title should be
I think working with absolute references, R1C1, might be easier here, but
somehow what I've tried, didn't work (the entire spreadsheet is based on
relative addresses (A1).
in a cell (Z100) put
Change G2 to whatev...Send from Word
When I hit the send button in Word or Excell I get a pop
up that say choose profile with Outlook in the drop down.
That is the only name in the drop down. If I hit OK I get
the following Message.
The MAPI Spooler could not be started. Close and then
restartall mail-enabled applications.MAPI 103 (0000004C7)
If I choose to set up a new profile I get a Microsoft
Exchange Setup Wizard. As I try to setup a new profile I
come to the following,
The following unrecoverable error has occured:
The .DLL file for this service is either damaged or could
not be found.
What versi...Embedding worksheet into Word
Has anyone had the experience where when they embed a worksheet into
Microsoft Word, a portion of the worksheet gets cut off?
Is there an easy fix to this?
...Unable to repy using word editor
When repyling to an e-mail I receive the following
message, "This form requires Word as your e-mail editor,
but Word is either busy, or cannot be found. The form
will be opened in the Outlook editor instead". I found
article 284900, that states you may get this message when
you have office 2000 and office xp installed on the same
computer. This is not the case on my computer, Office
2000 does not exist, only office xp.
Can anyone help me?
There appear to be a whole host of causes for this error message. Most have
no solution. Here are a few that do:
http://support.microsoft...Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 184.108.40.206 on Leopard 10.5.2, all updates applied to both.
A friend is migrating from Windows to Mac, and has come across
something that we're trying to work around.
He has some .ppt files with font glyphs in from a Unicode .ttf font (a
specific purpose font for showing the LCD display characters on a
piece of monitoring equipment). When we bring the font and .ppt over
to the Mac, the glyphs from the normal ASCII range come over into
Powerpoint 2008 fine, but the glyphs from the "private use" range from
F000 upwards a way don't transfer. In Powerpoint they show as spac...Autoshapes' visible problem
When I add some Rectangle autoshapes above the embeded chart, I find
it's hard to control it's visibility, They maybe hide when I select
some cell or activate chart. I want to know how to make them always
visible no matter what I select.
Thank you in advance! ^_^
You need to click on the chart before you use the drawing tool. In this way
the Shape and the Chart become one.
Bernard V Liengme
remove caps from email
"fujing1003" <email@example.com> wrote in message
Access 2003 XP SP2
I am having a problem with an update query.
Table is in a one-to-one relationship, referentail integrity and
cascading data are checked.
(The fileds I want to update are not in both tables)
Table name= payForward
Has 15 fields ie: ID, Name, MemID, Oct , Nov, Dec, etc
Oct-Sep fields are yes/no type
I want to "select" a field (Oct-Sep) via a query parameter and
repalce "yes" with "no".
Here is my query:
UPDATE payForward SET [Enter month]=No
The messages I get is
'operation must use an updateable query'
Wh...Reference: many to one
I have a form in which users enter information...I keep all controls
locked until the user hits a command button to unlock particular bound
This works really well, but becomes cumbersome to code when new
controls are added; e.g., adding the new control to the several event
procedures attached to the form.
Can anyone tell me how to refer to a group of controls once, e.g.,
give them a name; and then only have to refer to that name in the
I'm having trouble visualizing your situation.
It sounds like you are describing a form that is being regularly modified....How do I lock a chart so it will not update?
That's the question. I have my data in Excel and the chart in Excel but not
all the data cells are used. Everytimg I open the chart it wants to update
and I want it to stay the same.
Any ideas on how to lock the chart?
Just a few ideas:
You could lock the cells that are shown in the chart.
Or you could copy the cells and paste as values (assuming formulas were used
that update when other cells change).
http://www.wimgielis.be = Excel/VBA, soccer and music
"Locking a Chart" wrote:
> That's the question. I have my data in Excel and the chart in ...Microsoft Update 'left behinds'
Every time I download and install the latest Microsoft Update 'fixes' to
XP-Pro, the file space taken up by XP-Pro grows and grows. While this
will be an elementary question to many, is some of this XP-Pro file
space 'growth' being caused by stuff that the 'fixes' leave behind and
files that XP-Pro no longer needs?
If so, can these 'left behind' files be gotten rid of so as to reclaim
some HD space? Are there any pros and cons to deleting these 'left
Assuming that these 'left behind' files can be deleted, what i...