Need help to read Pie Chart Series Range
Excel 2003, I have an existing Pie Chart and want to extract the Ranges
My code below returns with a "Type mismatch" error.
Dim mySeries As Series
Set mySeries = ActiveChart.SeriesCollection(1)
Debug.Print mySeries.XValues (errors here)
...On-line services set up failed with "new & improved" Money update
Money 2005 Premium: with the mid-August unannounced update by Microsoft, I
lost my ability to go on-line. I reviewed the instructions inside Money and
tried to re-set the on-line service but I'm now in a loop that doesn't seem
to have any way to back out of it or to move forward successfully.
Instead of disabling the account first, which is listed in the long, weary
icon version of the update instructions, I went to set up online services and
now have the message "complete setup for online services" which apparently
will not work because I consistently get a message ...need Help for Migration Exchange 5.5
we`ve the following Configuration :
- Exchange 5.5 with SP4
- single Winwos 2000 DC
- configured both side ADC
a new Hardware should be used for an Exchange 2003 and second DC.
next steps i would do as following :
- Update ADC Version with Exchange 2003 ADC
- running Exchange 2003 forestprep, then domainprep, an after all
running setup to install Exchange 2003 in the same organization, site
- replicate system Folders and public Folders
- moving all Mailboxes to the Exchange 2003 Store
- configure the Exchange 2003 virtual SMTP Server to send outgoing
- reconfigure the F...Opening Excel Files #10
Once upon a time, like everybody else, when I clicked on an Excel fil
(say) on the Desktop, it would open for me. Now, I have to open th
Excel program first, then click file-open.
waynet's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2796
View this thread: http://www.excelforum.com/showthread.php?threadid=47464
<Tools> <Options> <General> tab,
"Ignore Other Applications".
-------------------------------...Switching between multiple open windows
I ran across an option to change how to switch between multiple open windows
on my desktop. It was an option to choose between hovering over a window or
clicking on it. Thinking that only having to hover over a window to switch
to it would save time, I selecting the option to hover... big mistake as it
just became a big pain in the a_ _ for me. Now I would like to change back
to one-clicking to change between viewed windows but can't remember or find
where the option is located. Any help will be appreciated.
On 2/03/10, rushl posted:
> I ran across an opti...Word Doc Macro help needed please!
I need to make a mocro that will work in a word doc. This macro would
start with  and count up one number each paragraph. For example
paragraph two would auto show  and so on. Any help would be
I have a word file which contains 100 pages. All the pages have name &
address of companies.(not in table) i have to transfer them to excel in
column format(for example first name, last name, address, phone etc)
can any one tell me code for this( i know how to open word & creat new
excel sheet) . I need code for how to reach to lines of word. r there
any thing like &quo...Access denied opening XML attachment
A user on my network cannot open an xml attachment in
Outlook 2003. It works fine in previous versions. It
says "access denied. Error processing resource." If the
file is saved to a drive, then it opens without a
problem. Is there some security configuration that would
cause this behavior? I have tested on multiple machines
and multiple users to rule out profile or other causes.
I have also checked security on the tmp folder the file
is trying to open from. Any insight would be helpful.
...Outlook 2003 does not start
I have MS Office 2007 together with Outlook 2003 installed on a computer
(Outlook 2007 is not installed as my PDA cannot communicate with the newer
Until today Outlook has had no problems.
After a Microsoft update. Outlook refuses to start with the error message:
"Cannot start Microsoft Outlook. MAP132.DLL is corrupt or the...".
Even if I rename MSMAP132.DLL, allowing Outlook to recreate the file,
Outlook succeeds in creating a new file - using an installation program from
Office 2007 (!?) - but - perhaps not surpringly - cannot start.
I should be grateful for any advi...Printing changes layout
I am printing a booklet on Pub 2002 - when I print one page, it prints a page
where everything has changed - resized, cut off the edges, etc. The worst
part - when done printing, it goes back to normal view and it actually
changes my layout to match what is printed - permanently.
Any ideas what is going on? I printed on both my Lexmark and HP printers,
does the same thing. I have Windows XP.
Look at your page layout, has it changed? I know this will happen to me
occasionally when I change printers. If I change back to the original printer
the publication will revert...open subfolders automatically on mail entry -- not happening.
Have a problem that happens in one Outlook 2002, but not another -- so I
know there's a likely setting someplace, but can't find it. I've even stumped
my company's IT people on this one:
I download mail through several rules (and accounts); and ship them to
various subfolders off of parent folders. What I desire is to have the email
automatically open the appropriate folder -- revealing the affected subfolder
-- when new mail comes into it. In one of my Outlooks (both 2002), this does
open automatically revealing the new highlighted message. But the other do...How do I display daily duty timings (day/night) of employees for .
I am looking for a template that would permit me to display the work timings
of my 30 employees. They either work the day shift or the night shift.
...Cannot open Money Deluxe 2007
New laptop, successfully using Money, then now I cannot open it. Windows
keeps shutting it down. Tried running as admin. Tried uninstalling, then
In microsoft.public.money, Karen wrote:
>New laptop, successfully using Money, then now I cannot open it. Windows
>keeps shutting it down. Tried running as admin. Tried uninstalling, then
What OS? Is there an error message?
Were you successfully using Money on that new laptop? Did the
problem occur recently? You might want to consider a system restore
point from before the pr...Microsoft 60 Day Trial Key
I have a new HP PC with Office 2007 Trial installed on it with an Activation
Assistant that I click the 1 button to get a 60 Trial key. When clicking this
I don't get a key but pop up message.
"The Microsoft Office Activation Assistant was unable to request your trial
activation key. Please check your Internet connection and try again. If the
error continues, go to www.microsoft.com/office/pctrial2007 to request a
trial activation key. "
So i then goto website and click on the link which takes me to here:
http://office.microsoft.com/en-au/products/FX101759...Downloads checking account information into my Money 2006 Savings
I purchased and installed Money 2006 today. I have a problem. Everytime I
import from my internet checking. It puts it into my Money savings account.
Any way I can redirect the imported information into my checking file?--
In microsoft.public.money, New Money 2006 user wrote:
>I purchased and installed Money 2006 today. I have a problem. Everytime I
>import from my internet checking. It puts it into my Money savings account.
>Any way I can redirect the imported information into my checking file?
Is the problem you have the one described in
http://support.microsoft....Help With Sorting #3
Gudday to all XL gurus.
I need some help on using the SORT function.
I have a list of 100 competitors in a scoring spreadsheet that I hav
I was trying to sort by surname (a-z). The problem is that this list i
generated elsewhere and contains VLOOKUP functions. Obviously if i hav
less than 100 competitors I end up with some cells appear blank bu
contain VLOOKUP functions. XL sorts them first and I want them sorte
last after the surnames (a-z). I cant add a helper column as this lis
relates to over 48,000 forumulaes and functions that are already added
If I add a helper column I have...Need help converting Microsoft Outlook calendar to Entourage.... At wits' end here! Please advise...
I have a Mac at work which runs Microsoft Outlook 2001 client on an Exchange
server. I have a calendar on this machine (stored locally, not on the
server) which has a ton of reminders programmed into it - very useful! Now,
at home I got a new Mac laptop with Entourage X. Is there any way to move
all of the reminders (appointments) from my calendar on Outlook to my
Entourage calendar? I've tried two things:
1) I exported the calendar info as a CSV text file, and then tried importing
it in Entourage. The problem is that Entourage import function seems to
think it's importing an Address...cannot open Outlook
When I try to open Outlook 97 I get the following error:
This program has performed an illegal operation and will be shut down.
EAX=00000000 CS=015f EIP=bff7b997 EFLGS=00000246
EBX=00000000 SS=0167 ESP=0063f8d0 EBP=0063fab8
ECX=c14eb7f0 DS=0167 ESI=0063fd58 FS=5217
EDX=bffc9490 ES=0167 EDI=0063fd58 GS=0000
Bytes at CS:EIP:
ff 76 04 e8 26 89 ff ff 5e c2 04 00 56 8b 74 24
0063fb10 7c6b2593 0063fd58 85762034 0063fb10 7c6b2484 0063fb10 85762034
85762278 85762278 7c6a7881 0063fb10 0063fb10 0063fb24 00000000 00000000
...Outlook not opening #2
I recently installed Outlook. When I try to open it, I get
the error message "Outlook requires Outlook Express 4.01
or greater". I do have OE 5.0 installed. Why am I getting
...Unable to open the outlook window.
I just downloaded Microsoft Office Outlook 2003 to my computer. When I try to
open Outlook, the window opens for about 2 seconds and then closes
I received an error message: "cannot start microsoft office outlook. unable
to open the outlok window. the server is not available. contact your system
administrator if this problem persist."
I'm have home based computer and don't have an administrator. Can anyone help?
Did you create a profile with settings (email account, POP3 and SMPT server
names, etc.) for Outlook to use?
Outlook Ti...error when opening .accdb file
I don't think this is a new issue but I can't seem to find the resolution...
I get an error when opening my Access 2007 formatted database stating that
the file could not be found, though at the same time the file opens
-- Error is intermittent. On occasions where the error does not occur, the
file opens normally (I have never had an occasion where the file did not open
-- I have only seen the error happen when I have a 'Display Form' set in the
Application Options for the 'Current Database'
-- The database contains macros, VBA m...Outlook Opens looking for Exchange Server
A computer club member wishes to used Outlook so that she can sync with her
Environment: Windows XP Pro SP2, IE 7, Windows Genuine Advantage installed.
When Outlook is opened, the program is looking for Exchange Server. She is
using a laptop with no exchange server available.
When performing Office Update, three items did not install all with error
1. Update for Outlook Junk Mail (KB943591)
2. Office 2003 update SP3
3. Security Update for CAPICOM (KB931906)
I suspicion that Office 2003 is a 60 day trial that has never been
activated. Are ...help with lookup formula (sheet 2, not a double post)
I need to make a formula using a lookup. The first spreadsheet is a
inventory (ALO INVENTORY JP). The second (P&G 103) is a chart tha
tells number of gallons of alcohol per foot/inch/fraction.
On ALO INVENTORY JP I insert the # of feet, inches, and the fraction i
cells R5 and T5. I want these numbers to lookup the number of gallon
off of the P&G 103 worksheet.
For example: P&G 103 (on inventory sheet) is 26ft 4 1/2 inches, i
should look-up to be 34572 gal. for the 26'4" and 55 gal. for the 1/2"
These two numbers should be added together and multiplied by the numbe
...Slow Open/Save over Network Connection
My client has an Apple XServe located in a "co-location" server farm
which is providing very fast and reliable network speeds (10 mbps DL,
11 mbps UL). His office location is using AT&T DSL with DL speeds
around 3.5 mbps. The directory that sits on the XServe is shared over
the internet so my client can access it from multiple locations. Most
of the documents are MS Word files. They are using Intel based iMacs
with the latest versions of MS Office 2008. The problem my client is
facing is the horrible speeds of opening, saving, and closing Office
2008 files. It could take up...Help!! Way to find users sending email to large amount of receipients.
Could some one tell me if there is a way in Exchange 2003
to find out what users are sending email to a large
amount of recipients?
I'm having some serious performance issues and I'm sure
it's some one sending email to a large amount of
I have a problem. I have a list of numbers that are in one column.
Alot of numbers 8000 or so, and I need to find if there are an
duplicates. I sort them so that they are in order, but having t
scroll through the whole list takes alot of time and hurts my eyes!!
I tried advanced filter but I can only find how to find duplicates in
Someone help me please!
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step...