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...outlook not senfing mail
i can receive mail, but not send. this is new. all was
fine for last 7 months. not sure what to do.
any error messages?
a bernstein ����:
> i can receive mail, but not send. this is new. all was
> fine for last 7 months. not sure what to do.
> thank you
...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...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?
...Sending a workbook as a mail attachment
Is there an easy way to send a workbook via email based on the date an
time? Our company uses excel for some of our reporting and rather then
having the reps remember to send the workbook i'd like to have it send
itself automatically - say on Saturdays or Sundays.
Nel post news:email@example.com
*Gord* ha scritto:
> Hey Folks,
> Is there an easy way to send a workbook via email based on the date an
> time? Our company uses excel for some of our reporting and rather
> then having the reps remember to send the wor...unable to access mail after re-enable account
After enable an disable account and change its password,
it can login to its mail account. What's happening. Is it
Thanks a lot
What is the error message when user tries to access mailbox? Does the user
still show in ADUC has having Exchange attributes? Have you looked at the MB
using ESM to see if it is disconnected?
"Raymond" <firstname.lastname@example.org> wrote in message
> After enable an disable account and change its password,
> it can login to its mail account. What's hap...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...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!
...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.
...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...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...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...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...Outlook 2003 E-mail Preview before receiving
I currently use an E-mail client called GoldMine that
allows me to preview e-mail sent to me on the server
before actually downloading/receiving it to my computer.
I find this extremely beneficial in weeding out the
junk/unsolicited and potentially virus-infected e-mail.
Is it possible to do this with Microsoft Office Outlook
2003? When selecting send/receive , it appears the only
option option is to actually download/receive the message
to be able to view it. If you are aware as to how I may
be able to preview first without downloading, please
provide instructions on how to achi...Autosave mail sent from delegated mailbox
I'd like to autosave all mail sent from User Xs mailbox in his inbox. His
mailbox inbox is available to three different users who all have it added to
their Exchange account.
This way I'm able to auto-create readable conversations in his inbox and all
users can see which mail have been replied to from this mailbox and what the
You would have to write an event sink.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Kristofer" <Kristofer@discussions.microsoft.com> wrote in message
news:DA61E72C-9405-4BF...trouble using signature picker
The signature picker is ghosted out does anyone know how to correct this ?
Signature picker was working earlier.
...XP Look and Feel in Windows 2000 using ComCtrl32.dll
I Want to have a XP Look and feel under windows2000 using VC++ and
ComCtrl32.dll and does any one have any idea please help me as basically iam
looking to develop a Skin
Waiting for your reply
You will have to draw many of your own components. You could purchase a
library like the one from www.codejock.com or www.dundas.com or or
www.bcgsoft.com use something like this:
These are for Office XP, but you'll get the idea. It's a ton of work:
"suresh" <s...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...Unread mail not showing up in Inbox
My Unread folder in located the "Favorite Folders" section in Outlook
shows that I have more unread mail than I can see in my Inbox. My
Inbox is normally sorted by "Received" so I can see the most recent
emails as then arrive. If I change it so that it is sorted by the
"From" column, I can see all the emails in the Inbox that are
appearing in the Unread folder. It is strange that they don't appear
using "Received" though. Emails that fall under any rules are not
affected by this so rules are irrelevant in this case I suppose.
Also, some additio...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)