"TOOLS" menu missing from menu bar #2
"TOOLS" menu is completely missing from the menu bar in Publisher 2003. How
do I put it back?
Might try a "detect and repair"
Meanwhile, right-click a toolbar, click customize, scroll down to built-in menus,
drag the tools menu to your toolbar.
Mary Sauer MS MVP
"Anil Gupta" <AnilGupta@discussions.microsoft.com> wrote in message
> "TOOLS" menu is completely missing from the menu bar in Publisher 20...Creating a Combination Bar Chart with 2 Lines
I am trying to create a bar chart with 2 line series. The Y-axis for the
vertical bars would be on the left and the Y-axis for the 2 line series would
be on the right (3 series were defined). The horizontal axis for all series
are calendar months (Jan, Feb, etc.) Every time I setup the chart my chart
only displays a single line, ignoring the other line series. The vertical
bars come out fine.
Any thoughts on what I am doing wrong?
Don't use the built in types. Make the chart using all columns. Select a
series that you want to change (click on it right in th...Vista, MS Access 2003 and MS ADO Ext 6.0 vs 2.x
I am running into an issue with MS Access 2003 installed on Vista.
Apparantly in the MS ADO Ext 6.0 version either (format, round, or
sum) is not in that DLL. However, when I link to v2.8 of the DLL, I
don't have an issue.
I am getting the following error message when running my query.
"Function is not available in expressions in query expressions."
Does anyone have other workarounds? I am distributing this
application in an MDE format, so I was wondering if the end users may
experience issues, if I link to my version of msadox.dll instead of
the installed version. I tried s...URGENT!!! Problem with row data being truncated in a copy worksheet sub #2
Dave, Thanks for responding. I tried this but I could not get it t
work in conjunction with the entire module. It dies right afte
copying and PasteSpecial Values It does not kill the temp file or loa
the newly created sheet into an e-mail. Any Ideas
DoctorV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=514
View this thread: http://www.excelforum.com/showthread.php?threadid=26863
You may want to post your current procedure.
> Dave, Thanks for respon...Cannot Start Outlook #2
I have just run the auomatic windows update on my local PC
and now Outlook 2000 will not start. It just hangs at the
splash screen. Outlook is configured to connect to
Exchange. Other PCs on the same Lan which have not been
updated can still connect. The updates installed were
824141, 823182, 826232, 825119, 828035, 828749. I have
unistalled all of these updates and Outlook still will not
start. Any ideas?
Does it start if you run this command from the command line, go to Start >
Run > type "outlook /safe" without the quotes but with the space before the
&...2 Email domains w/2 Act. Dir. Domains - Same Forest
We've had domain1.com (AD) setup and running in exchange 2003 for a year now
w/mixed win2k and win2k3 servers - email domain name is the same, domain1.
OWA works great and haven't had any problems. Our company is branching out
into a new business segment and I've created a new active dir. domain within
the same forest, domain2.local. It is NOT a child domain, but does sit under
the same forest.
I need to configure my front end/back end exchange 2003 boxes to do the
-receive email for both email domains (domain1.com and domain2.com)
-let users...Search Multiple Worksheets #2
Is there a way to search trough multiple worksheets for a specific value?
Other posts have mentioned to use VBA, but I have never used that before. If
anyone can give me some advice on using that or a type of formula to perform
that can search multiple worksheets.
There may be other ways but, while holding down the ctrl key select each of
the worksheet tabs you want to search in then select Edit|Find from the
menu. Type in the value you want and it will go to the first instance of
that value. Now if you are wanting to preserve a specifice value for
reference or ???, then...Match formula to match values in multiple columns
Hi all, does any friend know that how can I make below formula work
I am not sure I have understood correectly. Please go through the below example
With data as below if you need to retrive the name of the 1st Rank holder
D2 = 1
D3 = London
In D4 apply the below formula
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar'...print area #2
i cannot clear print area. when i select the print area
and 'file', 'print area',the options are not available.
When you use this command, Excel creates a range "print_area". Try deleting
New York City
"bronxxbabe" <firstname.lastname@example.org> wrote in message
> i cannot clear print area. when i select the print area
> and 'file', 'print area',the options are not available.
> any suggestions?
Perhaps you have two or more ...HTTP Error 401.2
I have installed MS CRM 1.2 on my Domain controller running windows 2003
standard server and email router on exchange 2003. My local ip subnet is
With ms vpn connection, I can access to ms crm by using outlook 2003 or
internet explorer by opening the default ms crm page remotely. However, if i
connect to ms crm with different subnet 10.0.0.x, i cannot connect to ms crm.
10.0.0.x subnet is routed to 172.0.0.x, where my users normally login email
from the exchange 2003.
What puzzle me is why i can authenticate from exchange 2003 but not ms crm
server on using the same...backup same set of servers from 2 DPM 2007 servers
I am changing the DPM server 2007. However, I would like to take this
opportunity to revise all protection groups so that I can restore bare-metal
any server from a single lTO-4 tape if possible.
During this "transitional period," I would like to leave the existing backup
settings on the older DPM server to continue to run while adding jobs to the
new DPM server.
Looks like to me that I have to re-install the agent on all servers so that
they can be recognized by the new DPM server. IS there a better way to do
this if my plan is possible at all?
...creating a function for dividing two columns
I am trying to keep track of softball stats. I trying to make a column of
batting averages. I have at bats in column b, hits in column c with the
results in column d. I cant get the function right so it will display the
use this =SUM(C1/B1) in cell D1. Format D1 as a number with 3 decimal
"cflan" <email@example.com> wrote in message
> I am trying to keep track of softball stats. I trying to make a column of
> batting averages. I have at bats in column b,...moving publisher #2
I bought a computer with publisher bundled (no cd). Now I want to put it on
my new laptop. How do I move it from the desktop computer to the laptop????
without the source CD...you don't.
Microsoft MVP Expression
"Cliff" <Cliff@discussions.microsoft.com> wrote in message
> I bought a computer with publisher bundled (no cd). Now I want to put it
> my new laptop. How do I move it from the desktop computer to the
I...Average speed #2
Having trouble working out average speed.
miles in a1 =14.3
time in B1 = 0:50:23 this cell has been formatted to HH:MM:SS
The formula A1/B1 brings back the wrong answer if I alter to A1/(B1*24)
still does not work correctly.
"jon" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Hi all
> Having trouble working out average speed.
> miles in a1 =14.3
> time in B1 = 0:50:23 this cell has been formatted to HH:MM:SS
> The formula A1/B1 brings back the wrong answer if I al...Keeps asking for password #2
I have followed all of the instructions given previously, I have deleted and
recreated my e-mail account but Outlook 2002 (Windows XP) still keeps asking
me for user ID and password every time it tries to send / recieve.
The strange thing is that I have two accounts and this is only a problem
with one of them.
one of your accounts is set to ask formy outgoing server requires authentication, see under tools ...accounts...
send...and then advanced email settings, or just double click on the email accunt , it wil give you the properties,
take it from there it should be the settings should ...Y Axis #2
I have two questions regarding the 'y' axis - in a normal line graph
Firstly, how do i get the 'y' axis to appear in the middle of the graph IE
to cross the 'x' axis at (0,0) instead of currently (in my graph) (-10,0)
Secondly how do i plot the line "X =2" which should just be a vertical line
on the graph?
I'm using Microsoft Excel 2007 any help would be appreciated. Thanks
Not able to test in xl2007 but from memory it should be the same as xl2003.
For a line chart, select the x axis and open the format dialog. On the
scale tab set Value (Y) axi...Printing on 2 sides of a page?
How can I print a 2 page spreadsheet on the front and back of the same
sheet of paper? Using Excel 2008.
It depends on whether your printer supports duplex printing. Check your
printer's features to find out. If it does, the setting will be available in
the Print dialog.
You can also do a "manual duplex" job by printing page 1 (or 'Odd pages'),
flipping the paper yourself, then print page 2 (or 'Even pages')... If it's
only 2 pages that might be the simplest approach.
"Rick"...Draft Folder problem #2
I'm running outlook 2000.
My draft folder is called draft1. Can't seem to rename it! There isn't a
folder named draft so what's happening? Isn't a big problem, but I should be
able to solve it and I can't. Help.
Thanks in advance
You could try to start Outlook from the run line with the /resetfoldernames
"Peter Brown" <email@example.com> wrote in message
How can I import an excel spreadsheet as inventory into Money...?
You're talking about the home inventory?
It's not possible without using a macro (i.e., there's no import function).
IMO, it's not desirable either, as the information is not easily usable in
Money. I keep my home inventory in an asset account, which has the huge
benefit of being a "normal" Money account.
If you need to import the inventory, there are Excel to QIF converters
available from third parties. I use the following:
"Marie" <...Saving data #2
I need to save data (results) from a base spread sheet program that i use on
a weekly basis. i am in the middle of building this program, and have just
discovered macros, but this, along with links is about my current knowledge
how can i automate to accumulate data from the base spread sheet (program)
when i clear all data from the program to produce fresh results the following
week, and to keep past data up to date and available for further use.
Any help would be appreciated.
With a combination of formulas and dynamic named ranges, it is possible to
just add the ...[ANN] Xinclude.NET 1.2 released
I'm glad to announce XInclude.NET 1.2 release.
What is XInclude.NET
XInclude.NET is free open-source implementation of XInclude 1.0 Working
Draft of 10 November 2003  and XPointer Framework Recommendation 
written in C# for .NET platform. XInclude.NET supports XPointer
element(), xmlns(), xpath1() and xpointer() (XPath subset only) schemes.
XInclude.NET has been tested using The XInclude Test Suite under
Microsoft .NET 1.0 and 1.1 on Windows 2000.
Changes since 1.0 release:
- Updated to new XInclude syntax and namespace according to new XInclude
1...The connection was dropped by the remote host #2
All day I've been getting email stuck in the outbound queue with the below
Message delivery to the host '126.96.36.199' failed while delivering to the
remote domain 'yahoo.com' for the following reason: The connection was
dropped by the remote host.
I've been able to send email to some domains but not all.....
I've restarted the exchange 2003 server,
Restarted DNS on DCs
Reset our firewall...
NSLOOKUP is good
Pings by name resolve
I can telnet to my mail server
I can telnet to other mail servers.
Can someo...GP Upgrade #2
We just upgraded to GP 10.0. We want the salesmen to be able to enter their
own orders, but we don't want them to be able to change the unit price or
the extended price on the order. Is there a setting I can use for this?
I might be wrong but I think thats a security issue.
> We just upgraded to GP 10.0. We want the salesmen to be able to enter their
> own orders, but we don't want them to be able to change the unit price or
> the extended price on the order. Is there a setting I can use for this?
> Than...Excel 2007
We have a spreadsheet that was set up to link to a database via a
system DSN. To simplify deployment of this, I'd like to change this
to connect via the connection string below:
I've done this for another spreadsheet, and it was easy (Data tab-
>Connections->Properties), but in this next spreadsheet the Connection
Properties for one connection are greyed out/disabled, so I can't
change the string.
Does anyone have any ideas how to enable these values again so I can
change the connection string?
...CRM 1.2 Leads & Searching
Hope someone can help - how do you search by Company Name field in the
Leads view, as well as Name field (by default). On older leads people's
names often get forgotten about, but the company name does not!
Is there a way of selecting which fields are searchable?
Afraid that you don't have this control in v1.2. v3.0 does give you the
ability to pick which fields to search though.
MVP - Microsoft CRM
"Adam Carter" <firstname.lastname@example.org> wrote in message
Hope someone can help - how do you se...