show another column when hovering on a point in a chart
Is it possible to show another column when you hover on a point?
I have 3 columns, A, B, and C for a scatter plot
I have B and C as x and y coordinates of a point,
and I'd like to have Excel show A when I hover on the point.
...Printing Newsletter in Publisher 2003
I have Publisher 2003 on an XP OS and trying to print a newsletter with 2
pages per tabloid size paper. I was able to do this OK with Publisher 2000.
It seems that the 2003 version does not have a "Book fold" option for the
layout. The Print Preview looks OK and shows page 6 and 1 for the layout.
For layout I choose "Booklet". What I get is page 6 and 1 on 1/2 of the
11x17 paper. Help!
Gary are you printing to a laser printer???
If you are, you are running out of printer memory.
Have a look in the properties of the printer driver, and change the settings
from Vector...Pivot tables in Excel
I am so happy, I finally figured out how to trick excel
into not showing the blank cell in a pivot table without
limiting my data set!
In the Pivot table layout move the field from row to
page. Then double click on the field and click on
the "blank" to hide it. Move the field back to row and
It seems like you always have to "trick" MS software to
do what you want.
...Formatting of Excel OLEs in Word is messed up after updating links
I have a Word document with multiple Excel objects pasted and linked to their
source files. Every time I try to update any of them, they revert to their
original size they had when I first pasted them in, instead of the formatting
I applied afterward.
I've tried to fix this by editing the links, but the "Preserve formatting
after update" box is greyed out on all of them.
Is there another way to force these objects NOT to revert to original size
every time I update? The way it is now sort of defeats the whole purpose of
linking them in the first place.
...Word saves document as .docx AND folder with weird stuff in it
Operating System: Mac OS X 10.5 (Leopard)
The folder has items in it like: <br>
word (older) <br>
docProps (folder) <br>
[Content_Types].xml (file) <br>
_rels (folder) <br><br>The document still opens if I put the related folder in the trash, but I prefer to just have a document saved. When I save a document as a .doc, it does not create the accompanying folder. I had this problem before and when I trashed the folder the document wouldn't open. Fortunately this is not the case. I have the latest version of Offi...excel, worksheet, set print area, position selection on printed pa
Office 07, Excel.
Print area is set, print preview displays selection, always on far left of
I want to choose the position on the page, eg centered or right aligned etc.
To get your printout to center on the page chose Page Layout, click the
Page Setup quick launch button (bottom right corner of the Page Setup group).
Choose the Margins tab, click Horizontal.
There is no command to right align a printout, but you can change the left
margin to force the printout to the left.
If this helps, please click the Yes button
"Eve Al...Can't edit print styles in Outlook 2007
Weekly calendar view to print - Define print Styles - Edit "CANNOT DISPLAY
THE DIALOG BOX"
I'm using trial version - shouldn't be the case????
I'm having the same problem where I cant edit the print syles ... please let me know what ou find out.
I think being able adjust the format and print the calendar is important, as I usually print my calendar.
EggHeadCafe.com - .NET Developer Portal of Choice
This is an Excel newsgroup. I would suggest posting this to an Outlook one
Microsoft MVP - Excel
Southampton...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?
...in excel how can we put formula to convert numericalfigureto word
for example :
in excel i have mention 25000.00 in numerical amount , i want to know how
can i convert in next colum , about word ?/;
How can i put formula to make the numerical in to words like 25000 in
numerical to twenty five thousands in word.
There is no direct functions to convert this. For a VBA solution check out
the below links
Jacob (MVP - Excel)
> for example :
> in excel i hav...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...Z Report shows zeros for an entire shift
How do I correct the problem described above? All receipts are printed
correctly, and all transactions seem to be successful. However, the Z report
that is run at the end of the shift prints all zeros? Any ideas???
I am having the same problem. All the transactions are successfull and I can
see the sale amounts and etc at crstal reports but all the z, zz and x
reports print "$0.00" amount. Does anyone know how to solve this problem?
> How do I correct the problem described above? All receipts are printed
> correctly, and all transactions seem t...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...Nested Styles in Word 2003?
Is it possible to create a nested style in Word 2003? An example would be to
make the first sentence of a paragraph Body Text bold but the rest of the
paragraph plain Body Text. I have used this type of style with Adobe InDesign
but haven't found a way to make it work in Word. It's not a big issue for me
as I have used character formatting over the Body Text style where
appropriate but I am curious.
Word can do this, but not with "nested styles" (there is no such
concept in Word). Instead, there is a way to apply a style to only
part of a paragraph. See
http://...mail merge with word 2007 and a riso
I'm having problems trying to mail merge a word 2007 document with a riso.
all goes well and I can preview all the documents and all looks good until I
try to finish and print it on a riso, and nothing happens. It works on word
2003 but not the new version. can anyone help?
Can you merge to a new document?
If so, try using the following macro from fellow MVP Doug Robbins to split
that document to the printer as separate jobs
' splitter Macro
' Macro created 16-08-98 by Doug Robbins to print each letter created by a
' mailmerge...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...Cannot Print a selection of ToDo's
I have a user who is having an issue when attempting to print a selection of
his Todo list. The print dialog will appear but as soon as he clicks either
print or print preview the dialog dissapears and no jobs are sent to the
print que. He is able to print other documents to this printer and the issue
occurs with all other printers installed (including a PDF printer).
Computer is running Vista business 32 bit w/ Vista SP2. Office 2007 Small
Business with Office SP2.
...Creating a Microsoft Words document from an existing Excel spreads
I need your kind guidance on how to create a new microsoft words document
using an existing excel spreadsheet? At present, I have an excel spreadsheet,
say "data.xls" containing data for example 6 fields such as COMPANY NAME,
DATE, ITEM1, ITEM2, ITEM,3 & QUOTATION TOTAL. Under these 6 fields are some
records of my customers.
COMPANY NM DATE ITEM1 ITEM2 ITEM3 QUOTATION
---------------- ------- -------- ------- --------
ABC Limited 3 Apr xxxxx xxxxx ...I want to send to junk
This is a multi-part message in MIME format.
I am a member of a club with several thousand members.
I want to be able to automatically junk all incoming mail that does =
*not* contain one of many key words. =20
When a member sends an email they will be required to insert their =
chapter name in the subject line. Our spam filter does not eliminate =
all junk mail. =20
charset=...I can no longer convert my files to pdf
I have Publisher 2003 and yesterday, my pdf menu on the top left disappeared
and I can no longer convert my Publisher files to pdf. I've even
uninstalled/reinstalled the Adobe Acrobat 7 and have also updated to 7.8 but
still no luck.
The next step was to uninstall and reinstall Publisher and still no luck.
Any one know what may be the problem? Thanks.
How are you trying to convert your files? When happens when you try?
MVP Microsoft [Publisher]
"darrellm" <firstname.lastname@example.org> wrote in message
news:A78B7B52-981D-4FB7-8625-EAD9...Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 22.214.171.124 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...Changing default Print copies
I have a workbook that has a worksheet with default printing copies of
3. Even when I go to page setup and change the number of copies to
print to 1 it will automatically revert to 3 the next time I bring up
the print dialog. I have also looked through the VBA editor at the
worksheet for any oddities and have found none. Does anyone know how
to change this permanently?
Thanks in advance.
>Even when I go to page setup and change the number of copies to
> print to 1 it will automatically revert to 3 the next time I bring up
> the print dialog.
Look at the defaults for you...Right Click Safari 404 and paste into Word 2008 only showing address
Operating System: Mac OS X 10.6 (Snow Leopard)
Example. I open gmail.com. Right click on the Gmail logo to "copy image" not the "copy image address" option. Then, I open Word 2008 and paste. All I get is the address, not the logo image. If I repeat and use Text Edit (Apple) instead, it works as expected. Is this a bug with Word? Or am I missing a preference setting here set up by default that needs adjusted?
Apparently it has to do with how Safari populates the Clipboard � I have no
problem pasting the logo with F...How do I break a large word document into smaller components?
I have a very large Word document (over 40 MB) that I update several times a
year. I would like to break it into smaller components so that only the
affected component would have to be backed up online. However, I still wish
to maintain the ability to create a table of contents and index for the whole
Is this possible and if so, what is the process to do it.
I am using MS Office 2010 beta running MS Windows 7 Home Premium on a 64 bit
You can simply make multiple copies and delete whatever you don't want from each copy.
For the mul...Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in?
On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> Is there a way to do this, or an add-in?
What version of Outlook are you using?
Ben M. Schorr, MVP
"Ben M. Schorr - MVP" <firstname.lastname@example.org> wrote in message
> On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> > Is there a way to do this, or an add-in?
> What version of Outlook are you using?
>...Show / hide design grid
For some reason thedesign grid in one of the queries that I have created
disappears. I can still see the tables and queries upon which the query in
question is based but the actual design grid has gone.
The grid cannot be located by doing a grid search using the scroll bars (all
the way to the bottom; across to the right one step; all the way to the top;
across to the right one more step\; etc etc)
I cannot find any setting that will restore the query design grid and cannot
find any reference to it on Google either.
I have Googled "Show hide query design grid", "Cannot see...