Printing problem from Excel 2007
I am having an issue with printing from Excel 2007. Many users when
printing from Excel with get several pages of non-sensical "junk"
printed out on the pages. If it actually prints what is on the page,
none of the items are in the cells, but look like they are just
randomly thrown about the page. I have found that this most often is
related to the Calibri font somehow, because I instruct them to change
the font to Arial and all prints fine. That being said, if the user
converts the Excel sheet into a PDF and print, it prints perfect. This
is a great workaround, but kind ...Excel Mail Merger Problem
When merging excel with word for..my currrency field is
dropping off zeros to the right of decimal point..if
field has $ 56.03, it imports correctly, but if it is
$56.00, it comes in as $56, if it is $56.30, it comes in
as $56.3...this process is for invoices..any advice (I've
Debra Dalgleish has given the following reply in newsgroups
and has also identified the following MS KB articles in
such as : http://google.com/groups?threadm=3DFA8DA8.6000209%40contextures.com
304387 - WD: Date, Phone N...Upgrading from Money 2002 #2
I have the original money 2002 that came with the computer and have never
upgraded. Which is the best version to go to? More importantly, when I
purchase and download the upgrade, will it go over the current program and
update all the information that I currently have?
Thanks and Happy New Year
The latest version in the US is Money+ aka Money 2008. Other geographies
have different versions.
Money keeps all your data in the .mny file not the program. When you install
the new version it usually remembers where your .mny file was, makes a copy
of it (for safety) and then up...excel charts #24
Is it possible to freeze a chart in excel and then add another chart with
different column widths without having the changes affect the first chart?
Move off the chart, press the Shift or Ctrl keys and select the chart.
Then right-click it and choose Format Object
On the Properties sheet select Don't move or size with cells
> Is it possible to freeze a chart in excel and then add another chart with
> different column widths without having the changes affect the first chart?
...How do I prevent "Help" from opening when I open Excel?
Whenever I open Excel 2003 the Help feature opens on the right.
How do I pevent this? I only want Excel to open with a new sheet.
Help or TaskPane.
For Help, you should be able to close it using the "x" and next time open
Excel should not display.
If TaskPane, go to Tools>Options>View and uncheck "Startup Task Pane"
Gord Dibben Excel MVP
On Mon, 12 Dec 2005 13:05:29 -0800, "Lee P" <LeeP@discussions.microsoft.com>
>Whenever I open Excel 2003 the Help feature opens on the right.
>How do I pevent this? I only want Exce...Excel 2007 Need to permanently change Normal settings for gridlines
I am using Excel 2007 for the first time and find the gridlines delineating
the cells are so faint as to be nearly indistinguishable. I can go into the
cell formatting and modify the normal style, and it is just the way I want
it. But I can't find a way to make Excel remember this and treat it as the
new definition of the Normal style. I don't want to have to redefine Normal
every time I open a new spreadsheet. Someone please help!
The changes you describe are changing the Border color and NOT gridlines.
Go into Excel Options and cl...Message "class not registered" opening sheet with macros Excel 97
I have created a document with Macros and is password protected. I have sent
it to several people who are able to use it - the one who can't is using
Excel 97 SP2. They are getting error message "class not registered" - could
it be the version they are using and how do I make sure they are able to use
This could simply be a version issue if you developed on a later version and
used controls from that versions object libraries. You should always use the
lowest version to develop on.
If this is not the case look in the VBE on the faulty machine and check
Have several spreadsheet files I use routinely. Three have recently
crashed after I added another sheet. In each case the document
recovery created a file missing all the color and text formats that
the file contained before the crash. Not sure what other changes may
Is there something wrong with the copy of Excel on my PC?
Could these three files be corrupt?
Is there a procedure to "clean-up" these files?
Thanks in advance for any suggestions.
sounds like they are corrupted. I would suggest to copy the data +
formats to a new, 'fresh' workbook.
...lost data when opening excel workbooks ; text import wizard popup
When opening many of my excel files ,which all have the same modification
date, I come across the text import wizard which states that my text in these
files is 'delimited'. All of the files ,including a few word doc.s have had
their data changed to show all " y " with two dots above the letter for as
far as the eye can see. No import or export has been done with the files and
no modifications were done on that date, as far as I know.
Is this a corruption problem or is their some 'fix' that I am overlooking.
Thanks for any ideas.
...conversion lotus 123 files to excel -- problem
I am converting lotus123 files to excel2002. One problem is that in lotus, literals are ignored when found in a cell within a formula. Excel on the other hand is not doing this and therefore causing #value errors on all the formulas where this occurs. Is there a way to handle this in excel other than manually having to change all the formulas?
...Outlook 2002 SP2
I have a user that cannot turn on or off his Out of Office Assistant on the
Tools menu, receives the following error:
"The command is not available. See the program documentation about how to
use this extention."
The Out of Office Assistant has been working for years, no changes have been
made to Outlook. The only way he can turn it on or off is by accessing his
mailbox via web access.
I have also tried KB article Q327353, but the resiliency subkey does not
exist in his registry.
His mailbox is on our Exchange 2000 server.
Is Exchange Extensions still selected ...Excel, how do I get ALT F C to work the same as ALT F Enter C ?
The above is an example, but it aplies to any menu. Before, if I pressed say,
ALT F, the drop down menu would appear and I could press, say, C and get to
the submenu. Now I have to press Enter, before the C, which is a bother.
On my Windows 2000 version 5.00.2195 with Excel '97 and Excel 2003 the
Alt F C still works.
What version software / Excel are you using?
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread: http://www....How do I display two excel pages at the same time?
I want to have two excel pages displayed on my computer at the same
time, but when I open both pages it uses the same master excel and when
I toggle between the two it won't open both of them up. I'm using office
2003. Thanks for the help.
snowtime's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25982
View this thread: http://www.excelforum.com/showthread.php?threadid=393499
Open both and then do windows>arrange and vertical (or any of the other
choices, I usuall...How do I add a hyperlink to an individual word in an Excel cell?
I am using Excel 2000 (not by choice) and I need to add a hyperlink to an
individual word within the cell, not the whole cell itself. For example in
the sentence "Click here or here to go to the appropriate web page." I want
the words "here" to each have a separate hyperlink.
Any ideas? I can manage some VBA too if necessary.
You can't do that in Excel.
You would have to use HTML or Word or some other means.
You could fake it, the entire cell would be a link, but you could
after assigning the hyperlink select another...PWS with diffrent templates & locations
I have two common questions but I don't find any other thread.
We work with MOPS 2007 on a MOSS farm. our default location for workspaces
is as subwebs under pwa. Now we want change the locations per customer. Each
customer has her own MOSS-Website where customer - documents are stored. Now
the project workspaces for each customer should be stored as a subweb of the
customer website. Each project has a custom enterprise field the the customer
name (the MOSS URL can be calculated)
What is the best way to implement this behavior and to reduce the users...How do I get excel files to open automatically from directories?
When I try to open excel files from the directory or from desktop I only get
a blank worksheet not the file. I have to then go through File Open to get
the file I want.
There must be a way to have them open automatically.
On Mon, 2 Jan 2006 21:22:01 -0800, Damian
>When I try to open excel files from the directory or from desktop I only get
>a blank worksheet not the file. I have to then go through File Open to get
>the file I want.
>There must be a way to have them open automatically.
Go to Tools -> Options -> Gen...FIX at bottom-right of Excel screen. Know what it means?
When ever I open a worksheet the bottom right corner of the screen (by the
CAPS, SCRL, etc alerts) FIX is showing. Does anyone know what is causing
It means you have fixed decimal settings checked under tools>options>edit
"Bobbert" <Bobbert@discussions.microsoft.com> wrote in message
> When ever I open a worksheet the bottom right corner of the screen (by the
> CAPS, SCRL, etc alerts) FIX is showing. Does anyone know what is causing
Tools>Options&g...How do I easily draw in Excel the Upper and Lower limits of a con.
How do I easily draw in Excel the Upper and Lower limits of a control chart?
I want to draw lines for target, min value and max values. How I can do
that without having to make complete data series?
Jon Peltier has just updated his site to include a Run chart that you could
revise to be a control chart:
Jon also has an example of a dynamic control chart:
> How do I easily draw in ...Question Regarding Excel 2007 Formatting Corruption
I am having a problem with Excel 2007 files losing all formatting
(merged cells, colors, borders, and data formatting (99% turns into
0.99)) when I open a file on our office server make edits and then
save the new file on the server. Each sheet usually has a mix of
locked and unlocked cells and I unprotect the sheet to make edits.
Also, something is fundamentally changed with the file as its size
doubles or triples. If I reopen the corrupted file and redo any of
the formatting and try to save it none of the new formatting is
retained either. Has anyone else ever experienced a pr...Outlook 2002 multiple file opening
In Outlook 2000, CTRL A would select all attached picture
files, then Open would, in my case, open the files in
With the 2002 version I cannot find a way to do this.
...Problem OL 2002 Email
I am having a problem with OL 2002 email settings. I
have two computers which I am setting up. One computer
works perfectly. The second computer I have configured
exactly the same...incoming/outgoing servers and ports,
etc... are all setup the same. On the second computer
when I press test email settings, everything tests fine.
But when I try to do a Send/Receive, I run into problems.
First, the POP3 tries to connect to the POP3 server twice
at the same time. (I am able to see this on my POP3
server console.) Second, the SMTP sending mail never
connects to my SMTP server. (Ag...Publishing Microsoft Excel Charts to the Web
I routinely publish Excel charts to a web site for
viewing in a web browser. When I do so, the charts are
too large to fit on one screen without scrolling. Is
there a way to make the charts fit the size of the user's
browser window when you publish them?
Embed the charts in a worksheet (right click, Location, As Object In:
Sheet Name), and size them to fit before exporting.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I routinely publish Excel charts to a web site f...Insert Page Numbers on Worksheet in Excel 2007
In Excel 2003, if you wanted to put page numbers on multiple worksheets in a
workbook, you grouped the worksheets and then added a header or footer, using
the page number function. All of your grouped worksheets would shows its own
But in Excel 2007, only my first worksheet is numbered when I do this (as
Page 1). What's the problem? Do I actually have to put a page number, one
by one, on each worksheet?
I cannot replicate your problem with 2007.
Grouped sheets behave exactly as 2003 did.
After grouping and adding a header of Page 1 did you do a print p...Textbox's truncated once printed (Excel 2000)
When using text boxs in excel if the data entry is larger than the text box
it does not print out everything in the text box. Is there a way to get it to
print out all the information contained in the text box. For the only two
solutions I can think of is
1) Make the text boxs bigger but my manager rejected the idea.
2)Cut an paste the information onto a excel spreedsheet then print it that
way by using a macro but that is a last resort.
1) 2) and 3) Reject your manager. If it doesn't fit, it doesn't.
4) Perhaps ... use a smaller font?
5) Refrase your text ...
Fran...Problms with Reply and Fwd- Outlook 2002
Running Outlook under Win XP Home. Outlook 2002 has SP3 installed. Since
installing SP2 to WinXP we have been having long wait times after clicking
the Reply or Forward buttons in the toolbar. We get the hourglass wait
symbol for a minute or longer. We get a prompt response when we click New.
Anyone have any ideas?
Once the hourglass goes away, do you have any problems with sending the
reply or forward? Have you tried using the Test Account Settings to see if
there is a problem with the account?
To be sure, I would try removing and readding the account.
Milly Staples [MVP - Ou...