Update Links Automatically
Running Excel XP and was wondering is there a setting which will
automatically update any external links that I have referenced, without the
dialog option of "Do you want to update links" etc
There's a setting you can toggle.
Uncheck "Ask to update automatic links"
Then the prompt goes away, but the links are updated.
This is your own setting--it affects all the workbooks you open, but won't
affect anyone else when they open that workbook. (They'd have to change their
> Running Excel XP...microsoft excel does not calculate
In large workbooks (> 10MB) I found that often Excel does not calculate. I
have to enter the cursor in the cell (or the formula bar) and press enter, so
that the formula is recalculated.
However, my calculation is set on automatic (Tools/Options/Calculate etc.).
Does somebody know why this happens and has an answer?
Try the last option on this page and see if it is likely to be your issue:-
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
--------------------...Exch 2003 SP2 and the IMF not blocking my SPAM!
Just installed SP2 on my Exchange 2003 server and reconfigured the IMF to
block SCLs 6 and above. Also, I set it to put 4's and 5's into each user's
Junk E-mail. This was working perfectly before the SP2 upgrade. We also
configured the SMTP virtual server to Filter.
I previously installed the SCL form into my Outlook 2003 to display the SCLs
on each email message.
Now when I send test emails to myself, I get 6's and 7's into my general
InBox. Any ideas on why this is happening?
Orange County District Attorney
If the SCL is being assigned but emails ...I cannot read forwarded messages. I only get an email address
For some reason, when someone forwards a message to me all that shows up is
the email address of the person who originally sent the message. Any ideas?
Change your View>Encoding setting.
> For some reason, when someone forwards a message to me all that shows up is
> the email address of the person who originally sent the message. Any ideas?
...question about spam
How is it that spam sent to one mailbox will end up in another not mentioned
in the "to" address. In other words how is it that spammers get mail
destined to Bob in Jim's mailbox?
Mostro <firstname.lastname@example.org> typed:
> How is it that spam sent to one mailbox will end up in another not
> mentioned in the "to" address. In other words how is it that
> spammers get mail destined to Bob in Jim's mailbox?
The BCC field. It can be used for evil as well as good.
...Entourage won't forward attachments
Operating System: Mac OS X 10.5 (Leopard)
Email Client: Exchange
I have a user that is no longer able to forward attachments. When she clicks Forward on a message that has attachments the message is preserved but the attachments are lost. I know she could use "Forward as Attachment" but then the person on the receiving end of the message has to open the original message to get to the attachment. These are just normal files in the attachments, jpeg's, pdf's ect.
Also, the machine is running fully updated 13.0.4 entourage EWS conne...Automatic Comments Boxes
I have a spreadsheet with two tabs that I use for work, One tab is inbound
quantities and the other tab is the order no of that quantity.
What I would like to do is where the quantity in a cell in inbound ie D8 is
greater than 0 then a comment is automatically inserted quoting the value in
D8 in the other tab.
If this is possible it would be a great help.
Assuming inbound quantities are in Sheet1,
Put in D8 in the other tab / sheet (for order no.)
Please respond in thread
xdemechanik <at...Automatic Dynamic Chart Ranges
I have an XY plot that refers to a set range of values on my worksheet
In this case, it is 8 rows long. I chose 8 rows because that is th
maximum number of data points that I will ever need. I have set up th
chart values so that they are dynamically calculated based on VLOOKUP
from other data. Sometimes there are only 2 data points, sometimes
or 6. The problem is that no matter how I set up the formulas, Exce
does not like the cells without values in them being included in th
chart series (I have hardwired it to include all 8 rows). I thought i
might ignore a blank ("" in ...Automatically forward spam
I have used the "Customize" menu to create/assign hyperlinks so that a new
message window will automatically come up with the contact's name in the
Now I want to forward a message using a hyperlink.
Usually my spam is just annoying, but sometimes I get really dangerous spam
that wants me to enter my bank account information.
I want to forward that to:
which is an agency that tracks this sort of thing.
Is there a way to assign a hyperlink to forward a spam mail to them?
...Outlook XP: No automatic receive
I have an Outlook XP installation on a networked Windowx XP
PC. It is linked to an MS Exchange server.
Outlook is set to receive messages automatically once every
5 minutes (Tools / Options / Mail Setup / Send-Receive). The
appropriate box is ticked, the time is set to 5 minutes, yet mail
only arrives when the user presses the Send/Receive button.
Any suggestions how to make Outlook do what it is supposed
OL2002: You Cannot Receive New E-mail Notifications in Environments That Use
the Network Address Translation
http://support.microsoft.com/default.aspx?scid=kb;en-us;305572&Pr...MSN Messenger 4: Forwarding Messages to Mobile Device?
> 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.
Am I misunderstanding MSN�s mobile device feature? Under the Mobile
Preferences, it says �Set up or edit account so my contacts can send
messages to my mobile device�. So I�ve set my account up...but how is it
activated? I thought it would work like AIM�s forward to mobile device
ch...Can charts automatically change by entering new range of dates
I am creating a Dashboard report for my Accounting department at work and I
have a weekly one I set up with links for the series of a chart to another
worksheet. Easy. But what I am trying to do is instead of creating a new
one each week by changing the link location for the data is there a way I can
just enter in a range of dates and the charts automatically change and filer
in the new data without me having to change the link in the series where the
data entry is coming from??
You can define a dynamic range that adjusts to dates you enter into cells. I
wrote a somewhat involved tut...NDRs generated due to viruses/spam
Has anyone come up with any way to combat returned mail that is generated
due to viruses sending out from the spoofed addresses of legitimate users on
your mail system?
I have a user who gets quite a few NDRs due to "no recipient", "full
mailbox" etc, for emails he hasn't actually sent. Seems obvious that it's a
virus infected machine out there (or a spammer) that is sending these out
"from" his SMTP address, and he gets stuck deleting the NDRs from the remote
mail systems the viruses are sending to.
Any solutions other than blocking the domains t...Allowing rules for auto-forwarding mails over OWA
I want to allow OWA-users to make a rule, which auto-forwards mails.
But the users always got an error and the message to try it again in a few
Facts: - it doesn´t mather if the recipient is an domain-user or not
- users can create such a rule over desktop-outlook, but not
- users can create all rules except auto-forwarding!
- Exchange version: 2003 sp1
And the error message is ... ?
dOcToR bEaT wrote:
> Hey guys!
> I want to allow OWA-users to make a rule, which auto-forwards mails.
> But the users alway...Using a custom form kills forward/reply arrows in the inbox?
I installed a custom email form in Outlook 2000 and the "Forward"
and "Reply" arrows on mails in the inbox disappeared.
The arrows reappear on new mails when I swap the default back to
IPM.Note but as I really have to use this custom form the absence of
the Forward/Reply indicators is a pain.
Has anybody come across this issue before?
Is there a method to turn these "flags" back on or do I have to dig
into the code in the custom form?
The custom form is just a modied IPM.Note that provides access to a COM
Known issue, dating back t...URGENT: Receiving spam email sent from myself!
During the past week I have been receiving ALOT of spam email from 2 of my
email addresses (custom domain - we'll call "MyDomain.com"). My dad called
and said he's also been receiving them too! (From mostly
Address2@MyDomain.com.) I use webhost4life as my hosting & email company.
I did a thorough virus scan with Avast and found NOTHING. I did a thorough
spybot check and found NOTHING.
What should I do? How can I find out WHERE they are coming from and STOP
Here's the email headers of the last 6 SPAMs....
Return-Path: <me...How do I auto forward a message in outlook ?
I wish to forward a mail to a distribution list that I have set in Outlook.
Does anyone know how I do this / if it can be done?
What version of Outlook? Have you tried using the rules wizard to do this?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
Banquo <Banquo@woolleynet.demon.co.uk> asked:
| Anyone ?
| I wish to forward a mail to a distribution list that I have set in
| Does anyone know how I do this / if it can be done?
| thanks...Automatic send / receive at startup Outlook 2003
The subject says it all
Thanx in advance
<email@example.com> wrote in message
> The subject says it all
> Thanx in advance
Okay. Since your Subject says it all, and since it doesn't pose a question,
then expect no replies because you didn't ask for any help. For all you've
told us, auto send/receive WORKS on startup of Outlook 2003 and you simply
want to declare the obvious.
My apologies , my problem is that auto send/receive doesn't start on
startup of Outlook 2003 and that i don&...Spam Domain Blocking
Through junk email filtering you can block a domain. But how can one block a subdomain - for example how can I block any email which comes from firstname.lastname@example.org, when the spam senders constantly change the subdomain?
Where the filter 'name' is constantly changing you will have to use some
other method. e.g. subject/message text, or from contains, though no good if
yahoo.com and you wish to receive some of this.
Or try one of the spam blocker apps, eg www.cloudmark.net
"Pier" <email@example.com> wrote in message
news:19972491-5C78-4...Automatically Update Excel Links
I have an Excel spreadsheet that resides in SharePoint. Every time the
spreadsheet is opened a message appears asking is links (within the
spreadsheet) should be updated.
Is there any way; using formulas, VB Code or some other magic :-) to have
the spreadsheet automatically update and to have it update every hour (or
other time period)?
Any help would be greatly appreciated!
Thanks in Advance
...Send, Send/Receive, Forward
Hi and thanks for reading my appeal.
I have just loaded Outlook using Windows 98 and there is
no Send, Send Receive or Forward button to be found
I have spent all day with Outlook Help going through Tools
and Customise and Options etc and zilch.
Thanking you in anticipation.
While in your inbox, click on View, Toolbars, Standard....does that help?
maggie evans wrote:
> Hi and thanks for reading my appeal.
> I have just loaded Outlook using Windows 98 and there is
> no Send, Send Receive or Forward button to be found
> I have spen...Outlook 2000 rules wizard won't forward emails
I have created a rule to forward mails from particular
senders to another email address (a blackberry device).
The rule won't run on send / receive. It will run
manually with run now. Is this a bug or am I just not
...local pritners adding automatically to remote computer
When I am remote desktop a computer my local pritners are adding
automatically to the remote computer. What is the solution to stop adding my
local printers to remote machines.
if you use mstsc directly or short cut w/o the /v: part, you can
-click on the option button
-select the local resources tab
if you want to apply this as default to all connection,
- click general tab
- click save button
otherwise you want to click the saveas something that you will use for
disallowing local printer on remote connection
"Siva Prasad Kakani" <Siva Prasad Ka...Removing automatic links
I cut columns from one work book and pasted it in another. Now when
open it, a prompt states that it has automatic links and to eithe
click yes or no.
Is there a way of getting rid of this because I want to deleted the ol
workbook or am I stuck with it?
Many thanks guys
Message posted from http://www.ExcelForum.com
The easiest way to find the links is to perform a search or a replace
If the cells contain formulas that refer to the original workbook an
need to refer to the current workbook you could try replacing th
workbook name with a blank replacement. This will only wo...sorting data and automatic graphs
i have a large amount of data that is an xy scatter. it is xy data that
pertains to many subjects. i need to make a graph for each subject. as of
now i make the first one and then cut and paste to a new one, use source data
and change the x and y data. this does take me a long time since i have alot
of subjects. is there another way to pick my data range and sort by subject
to make differenct graphs without cutting/pasting and constantly changes the
source data. i tried tinkering with a pivot table but everytime i changed the
table, all tables changed.
There may be depending on the s...