Excel 2007 Chart auto update not working
Every other worksheet my charts auto update, except one. Of course it's one
that changes often... the data on the chart sheet updates, but the chart
doesnt. I checked all the settings and they're right. Frustrating!
I have the same problem. I have a workbook in Excel 2007 (SP1) where three
charts are displayed (automatic calculation selected). Only one of them auto
updates when the source data that it is utilizing changes. The other two
don't auto update. When I look at the source data in the chart, it shows
that it is getting the data through a regular cell reference. ...Current Issues Article Archive
A growing archive of fascinating media articles on current issues & affairs.
Available at Arcis Foundation Website:
Posted by News Bulk Poster
...Re: auto accept utility
An MVP not recommending MS AutoAccept Agent, tsk tsk. I am using http://www.microsoft.com/downloads/details.aspx?FamilyId=3D0884E6-C603-491D-BF57-ACF03E046BFE&displaylang=en and it works great, love the return codes for automated reply processing.
Exchange Admin and All Around Windows Monkey
In the last exciting episode, "Kevin Queen" <email@example.com>
> An MVP not recommending MS AutoAccept Agent, tsk tsk. I am using http://www.microsoft.com/downloads/details.aspx?FamilyId=3D0884E6-C603-491D-BF57-ACF03E046BFE&displaylang=...Auto numbering #3
Wish to use auto numbering system for test sheets, i.e., every time I open
my test sheet, a cell with a number in automatically increments, is this
possible in excel?
You can use a macro:
if isnumeric(.value) then
.value = .value + 1
If you're new to macros, you may want to read David McRitchie's intro at:
I'm trying to get a macro to run as soon as I run a workbook, can anyone
give me an example?
either put the macro in the workbook_open event of your workbook module
or rename your macro to auto_open()
matt rich wrote:
> I'm trying to get a macro to run as soon as I run a workbook, can
> anyone give me an example?
...Unable to Archive
I have a Strange problem on a user here, using outlook
2000 using Corporate Email to connect to our Exchange
servers. Basically whenever a user tries to archive data,
Outlook goes through the motions and processes the
selected folders, but the .PST file is empty. The only
thing that shows up is the Deleted Items, but it is empty.
No matter what date I start the archive from or where I
choose to put the archive file.
I've tried different logging on as the user on a different
PC and get the same result. it just started to happen
without any prior issues.
How do I stop Outlook from starting automatically?
Bill <firstname.lastname@example.org> wrote:
> How do I stop Outlook from starting automatically?
If it's in the Startup program group, remove it.
...Errors occurred while archiving
I had had some recent problems with opening outlook after an old version of
WinFax Pro was installed. It has since been uninstalled and outlook works.
Now, however, I am getting the following errors which show in in the archive
Error while archiving folder "All" in store "Personal Folders". Cannot read
archive properties from folder All. Cannot create archiving properties.
Could not complete the operation because the service provider does not
Error while archiving folder "" in store "Personal Folders". Cannot read
archive proper...archive date not working
When I try to archive my money file, it does not use the
date option. I asked it to archive, selected a date of
1/1/00 (and also 12/31/99). When the archive was created,
it had everything from 1995 through today, 2003. I just
purchased Money 2004 Deluxe. Have never used archive
Suggest you forget all about archive - it is an absolute pain in the butt
and causes more problems than it theoretically solves.
Many of us have been very happily running for 8 years or more without ever
Microsoft MVP - Money
Money 2004 quit updating automatically. I have check the update setting and
it is set for every 15 minutes, but does not activate. I can manually click
update and everything works fine.
...Auto transfer of row/ update
Hi Im trying to setup a system for our 'goods in' the attached shee
would be on a pc at the 'goods in ' area hooked up to our network. I
the office we have a individual parts list for each job. I want to b
able to input a component on the parts list and when I enter a orde
number in the cell at that row it will copy the row to a row on th
attached sheet (goods in). When the tick box is ticked i.e th
component is 'in' I want a cell on the parts list (in the office)to sa
'goods in' or some kind of alert. Any help would be great someone ha
suggested using a VLOOKU...Archive Modified date
QQ, I have just moved users from one mail server to another. Now, archiving
no longer works. I looked at this and found out that archiving works with
modified dates and since this was changed recently I am stuck.
Do you guys have any idea, if their is a work around for this. Users have
lots of sub folders.
Not really...you can manually archive by dragging and dropping items to the
archive folders, or you might be able to use one of the 3rd party solutions
listed at http://www.slipstick.com/addins/housekeeping.htm.
MVP - Outlook
*** Messages sent to m...Auto Filters
Hello from Steved
When using Auto Filters and I am in cell A2 is their a
Macro I can use so I can use to put it back to cell A2.
An example would be in cell AA200 to put it back I would
have to go into filter and select all for it to go back to
A2, there has to be a better way.
ps I'm new to Auto Filters
not really sure what you're trying to achieve. what do you mean with
'put it back'
> Hello from Steved
> When using Auto Filters and I am in cell A2 is their a
> Macro I can use so I can...form combobox auto expand
hi, i have some comboxes on my form. I wanted that to expand
automatically, when it gets focus. Any help in this regard is
Private Sub ComboBox1_Enter()
> hi, i have some comboxes on my form. I wanted that to expand
> automatically, when it gets focus. Any help in this regard is
> appreciated. Thanks.
On Jan 26, 3:54=A0pm, Jeff <J...@discussions.microsoft.com> wrote:
> Private Sub ComboBox1_Enter()
> =A0 =A0Me.ComboBox1.DropDown
> End Sub
The pages in one of the our publishing site are around 1500. So it?s showing effect on search crawling index and sometimes throwing an error like System out of memory (usually in full crawl). Our ram size is 4 gb for index server. Is there any method for archive the pages in page document library. And the important thing is the data must be handy, so the archival process should accommodate ability to retrieve the archived content quickly. pls suggest me.
Thanks in Advance
Submitted via EggHeadCafe - Software Developer Portal of Choice
Consuming WebServices...Transfer archived emails in MSN to Outlook
How can I transfer my archived emails(Maildb) files from
MSN9 to Outlook 2003.I found one method that is to
transfer the archived emails to the Server and download
again to Outlook.
But is there a way to transfer those Mail db files
directly from MSN9 to Outlook 2003 within the computer? Do
the files arise any conflicts.
Praveen Kumar Perka <email@example.com> wrote:
> How can I transfer my archived emails(Maildb) files from
> MSN9 to Outlook 2003.I found one method that is to
> transfer the archived emails to the Server and download
In RMS is there a way to auto batch credit card transactions at the end of
Sadly, no. We have looked into creating a customization that would do this,
though to little success.
Retail Information Technology Enterprises
"jstone" <firstname.lastname@example.org> wrote in message
> In RMS is there a way to auto batch credit card transactions at the end of
> the day?
...Formula to auto-assign a number
I have a spreadsheet that lists parts and associated quantities. The user
will be able to add and delete parts from the list. I am looking for a
formula that will automatically assign a “dash number” to the parts. The dash
numbers will be in numerical order and skip any part that has a quantity of
Original Part Qty Automatically assigned “dash number”
The user may change the quantities on the list therefore I need to formula
to automatically recalculate the “dash number” based on the user inputs. For
Revised Part Qty Automatical...Auto Sheet Names and Date cells
I have an excel document which it is intended to have a sheet for each
work week. In each sheet I have cells that have the dates for Monday
through to Friday.
Everytime I create a new sheet (from a template sheet using the copy
sheet method) I have to name it manually and then change the date of
the Monday cell so that Tuesday to Friday can be calculated.
What I would like is for the the date columns for Monday to Friday to
be automatically calculated, and if possible the name of the sheet
e.g. My sheet names are
12th - 16th Sept | 5th - 9th Sept | 29th Oct - 2nd Sept
these shee...Auto save contacts when replying to e-mails
I would like my contacts to be saved automatically when I e-mail them. I am
using outlook 2007. Can this be done?
"BettyE" <BettyE@discussions.microsoft.com> wrote in message
> I would like my contacts to be saved automatically when I e-mail them. I am
> using outlook 2007. Can this be done?
Not without code or third-party software.
Brian Tillman [MVP-Outlook]
...Auto-displaying a template when Excel is launched
I would like a template to auto-display when Excel is launched. I placed the
..xlt in the XLSTART folder and modified Excel Options in Options>General>"At
startup, open all files in" option to point to the location of the .xlt.
The .xlt is failing to auto-load when Excel is launched. I am following the
exact instructions of MS Help. Aurgh!!!
I don't read the help that way.
I read it to say that if you have a template named book.xlt stored in XLStart,
it'll use that as the basis for any new workbook--and that any workbook (.xls)
that's in that folder will be op...Outlook 2003 Archive Problem
I am using Outlook2003 SP2 on Windows XP SP2 on my laptop with VPN
connection to my office Exchange 2003 server. I try to run archive from FILE
> Archive > , to archive all my inbox folders but it doesnt work. It worked
ok previously in my outlook 2000. Any tricks I missed?
Is the archive PST file still available on your machine? Have you tried
running ScanPST.EXE on it? Do you receive any error message?
"Microsoft" <email@example.com> wrote in message
> I am using Outlook2003 SP2 ...Auto Recover for MS Office 2003?
I'm using MS Office Word for 2003 and keep getting a message that says the
auto recover is disabled. For the life of me, I can't find out how to enable
Anyhelp would be very much appreciated. Thanks!
In 2003 Save AutoRecover Data is controlled by settings in Tools> Options>
Save. If the feature is already activated but you still get the message it
could be due to something that's preventing the necessary temporary files
from being created.
On 1/2/10 8:08 PM, in article
F45E812D-CF15-4CCF-A20D-30104C73E6CF@m...cannot open money w/o auto reinstall
i installed money 2004 from a network resource that i now no longer have
access to. the program has worked fine for months, however now when i open
money for some unknown reason it immediately and automatically tries to
reinstall (or reconfigure?) money from the network resource i originally
installed from. because i do not have access to this network resource, i
cannot open money at all.
why would it try to reinstall after months of use? i've had no other
problems with the computer. what can i do?
...How to disable the pop up for enable auto update?
I have imported an external link in to excel, and set it auto update when it
opens, but whenever I open this file, it pops up a window to confirm whether
you like to enable auto update or not.
Does anyone have any suggestions on how to disable the pop up window for
enable auto updating links?
Thanks in advance for any suggestions
on the menu bar>edit>links>startup prompt
pick you choise.
> I have imported an external link in to excel, and set it auto update when it
> opens, but whenever I open this file, it ...