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...Microsoft CRM using Firefox
Would anyone by chance know if CRM will work correctly on Firefox.
Currently, I have employees that are using Firefox and are encountering the
same issue as IE [Internet Explorer bombs out and states that it has
encountered problems...]. I am just having employees use IE to prevent
problem. Thank you for your comments in advance.
Install a Firefox extension called IETab
"Marcos" <Marcos@discussions.microsoft.com> wrote in message
> Would anyone by chance know if CRM will work cor...NESTED IF STATEMENTS #2
Having a little problem in an excel class, hoping someone might be
able to help. I'm trying to fill in the discount column on a
spreadsheet with the following info. The problem states use a nested
form of the IF function to calculate 15% if Amount is greater that
$300., 10% if Amount is greater than $100., and 0% if Amount is less
than $100. The Amount column is cell D5. Anyone know how to write the
formula and explain how to go about it? Any help would be much
Let's see. This is homework so you should come up with the answer yourself.
Did you start by looking in the he...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...Multiple PST Files #2
I am running Outlook 2003 and would like to have Outlook use two
different .pst files (one for my work stuff and one for home) on the
same computer. Is it possible to do this?
If so, can I can I configure one of the pst files to get e-mail from
one account, while the other pst file is configured to get mail from
the other account?
Yes, you can create multiple PSTs. I keep mine stored in
the same file location but with different names.
Depending on which version of Outlook you run, you can
creat a new pst from file/new/Outlook Data File (I run
Outlook 2003 but had multiple P...lost menu bar #2
HELP!!! The main menu bar is missing off my excel sheet
and I can't seem to find anyone to help me get it back.
The menu I am missing is the one that includes - File,
Edit, Insert and etc. I have tried...right clicking -
customize - toolbars, but I don't seem to have the needed
item. Anyone with suggestions - please reply...
if you right-click on the menu bar you should see an item like
'General'. Check this item
JoEllen OSBDC wrote:
> HELP!!! The main menu bar is missing off my excel sheet
> and I can't s...Creating a template using Publisher
I need help creating a neighborhood directory template using Publisher and
merging an Excel spreadsheet into it. It keeps printing multiple pages of the
first page after I merge.
What version Publisher?
If you have 2003 use the catalog merge for your directory.
Otherwise you need to setup your page as though it is labels. Determine the size
of the area you need for each entry, select labels in page setup, type the size
you determined in the page setup. Adjust the gaps and margins when you are ready
to print (2000 and bel...iPhone Email to Entourage Using Exchange
Operating System: Mac OS X 10.5 (Leopard)
When I answer an email on my iPhone, it does not register it in Entourage as answered. This function worked fine until the business I work for put everyone on Exchange. Is there a setting for this that I can change? <br><br>Thanks!
...Using Sumproduct when some of the values are null
I am having a problem using Sumproduct when some of the cells have
null values. I will try to describe the problem. Please let me know
you need additional information. Do any of you have any ideas of how
can fix that sumproduct to get it to work?
A B C
Row Trend Claims
5 Emergency $0
6 Emergency $0
7 Emergency $0
8 Emergency 81.68% $24,444
9 Emergency 35.00% $164,758
10 Emergency 35.00% ...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...Is anybody using Symantec Enterprise Vault?
A vendor has recommended this solution to us, I have looked at the datasheet
for the product and it speaks the right language but I was wondering if
anybody on here uses it in a live environment and what their opinion of it
...Operating a small passenger service
I am hoping someone has managed to customise outlook in a way that allows you
to use the programe to manage bookings on a small passenger service.
I.e input a new booking, number of people, location etc. Then email the
days bookings to the different drivers. Maybe it could also be set up to
know how many seats are avialale to reduce the risk of double booking?
Im using Outlook 2003.
...Thread Synchronization #2
I have a shared resource, say a file which is to be accessed between
threads. There are say 20 Read threads and 1 Write thread. When the Write
thread is writing into the file, the Read threads should be blocked, and
1 read thread reads, the Write thread should be blocked. The Read threads
read simultaneously, but only say 5 at a time. What kind of synchronization
mechanism can I use for this?
You can create a mutex a adquire it when a read operation start, check it
before start any write operation.
You will need another mutex ...Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 126.96.36.199 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...using dates Part 2
Karl was great in helping me get to this point with dates, now I'm wondering
if we can take it 1 step further?
For Activity Dates prior to 2/1/2007 they are using a normal reporting year
and the formulas below take care of Activity dates >2/1/2007?
So for example prior to 2/1/2007
1/1/2006 would have a B_Qtr of 2006-1
1) B_Qtr - 2011-1 --- Format(DateAdd("m",11,[ActivityDate]), "yyyy - q")
2) Year - 2011 ---- Year(DateAdd("m",11,[ActivityDate]))
3) Qtr - Q1 ---- Format(DateAdd("m",11,[ActivityDate]), "q")
Than...Send 1 address to 2 mailboxes
I want to create an address and have any mail sent to that address delivered
to two separate users' mailboxes. How can I do that.
I've tried simply adding the address in the two users' "Email Addresses" tab
in the User's properties of ADU&C. But it wouldn't allow me to add the same
address to the second user ("This email address already exists in this
I've also tried creating a new user for the address and forwarding the email
to the 2 other users (Exchange General tab - Delivery Options button -
Forward To field). But ...Publisher 2000? #2
Is there a place where I can still get version 2000? I've been looking, but
all I can find are updates and the 2007 trial. My computer can't run 2007.
*If* if can be had, try something like eBay. (I wouldn't buy software that
way but that's just my preference.) You may find you have better luck
finding a leftover copy of Pub 2003 from some online retailers. (I actually
prefer that over 2000.)
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Jason" <Jason@discussions.microsoft.com> wrote in me...Compare 2 different workbooks with the result in a 3rd
I have two workbooks (2005 Sales, 2004 Sales), which track daily results in
half hour intervals. I want to be able to show the increase in 2005 in a 3rd
workbooks. The first two workbooks are identically formatted. How can I do
this? Many thanks to all in the forum who have helped in the past.
If the data is in exactly the same position in the two worksheets you could
copy/paste one's data to a new worksheet and then copy the second's, doing
an Edit, Paste Special, Subtract on top of the first's data. This is
admittedly crude but it is easy to do.
&q...Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in?
On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> Is there a way to do this, or an add-in?
What version of Outlook are you using?
Ben M. Schorr, MVP
"Ben M. Schorr - MVP" <firstname.lastname@example.org> wrote in message
> On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> > Is there a way to do this, or an add-in?
> What version of Outlook are you using?
>...import from eudora #2
I have used Eudora for many years, but am planning to set up my email in
outlook. I want to move all of my mailboxes to outlook. Eudora does not
have an export function. Do I need to go through something else, such as
Thunderbird. I can't use Outlook Express, because it only imports through
Eudora v3.0. I have 4.3.
Any thoughts on this?
"Nate Rosenthal" <firstname.lastname@example.org> wrote in message
>I have used Eudora for many years, but am planning to set up my email in
>outlook. I want to move all of my m...trouble using signature picker
The signature picker is ghosted out does anyone know how to correct this ?
Signature picker was working earlier.
...Outlook 2007: is there a way to use it as a Diary
I'd like to keep a daily journal of important notes, etc. In other
words , I would like to keep a Diary. Does Outlook 2007 have this
Sure - Ctrl+8 to view the journal or you can create a Mail and Post folder
type and post to it.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH...Find what control is using a data item
I built a form, then deleted 2 columns from the source table and now I get a
popup asking for the value of those 2 columns. The problem is, I don't use
those columns so I need to find what on the form is refferencing the deleted
I have looked at the control drop down on the properties window and the tab
order window and can't find a control with either one of the missing column
How do I determine what is trying to refference the deleted columns?
I found the problem, the column was still referenced in the underlying query
that fed the form.
"MeSteve"...VBA using an image as a toggle switch
Hi hope you can help.
I know next to nothing about VBA and have adapted code below from stuff I
I simply want to show hide portions of my page to cut down on screen
I have assigned my macro to a screen image but was wondering if I could have
a hide and unhide under the same button.
Any help would be much appreciated
Application.ScreenUpdating = False
Rows("25:75").EntireRow.Hidden = True
Rows("98:148").EntireRow.Hidden = True
Rows("171:221").EntireRow.Hidden = True
Rows("244:294").EntireRow.Hidden = T...Read file info using SMO locks database!
I'm using SMO from C# to restore a database from a backup file. Since I want
to re-use the same datafiles I try to read the datafiles in my destination
database and call RelocateFile to use these filenames during the restore.
Everyting works fine except when I try to read the current datafilenames
(see code below). If I skip this code and just hardcode the paths in
relocatefile everything works fine.
Database db = svr.Databases[destinationDBName];
foreach (FileGroup group in db.FileGroups)
foreach (DataFile file in group.Files)