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 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
tools>ref...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...Sending Letter to Contact Crashes Outlook
In Office 2003, if Word is open and I use Actions > New Letter to Contact,
Outlook freezes up. On the other hand if Word is not open, "New Letter to
Contact" works fine. Any explanation?
Never seen it.
You'll have to supply at least _some_ troubleshooting information.
Error messages? Configuration changes to your setup? Did it ever work
"Terry Smerling" <email@example.com> wrote in message
> In Office 2003, if Word is open and I use Actions > New Let...Excel 2002
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.
...transfer inbox in table format to word
In my older version I could cut and paste the table
format in Outlook to a word file. Now I don't seem to be
able to do it although I can print the file in that
format within Outlook. When I export the inbox to word I
get the whole text not just the headings. Is it possible
to transfer the table format to a word file?
...cannot open outlook 2000
"this opration has been cancelled due to restrictions in
effect on this computer" I have already tried the steps
listed in MS Knowledge Base article 310049, with no luck.
Any other suggestions ?
...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...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...Access 2007 Reports
I'm using an Access 2000 mdb (split ends) in Access 2007. I cannot up-
convert because other terminals don't have Office 2007.
It works as a database just fine except:
When I try to change a (front end) report from the default printer to
another specific printer in design view, page setup, it all LOOKS good
except it does not save my changes upon return and goes back to the
I never had this problem with earlier versions of Access and the
specific printer in questions works fine with other apps and
Any ideas people? Many thanks.
This is a known prob...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...Not able to open imported accounts 4.0
We have a situation where we've updated a client from 3.0 to CRM 4.0 and have
an import that brings in new Accounts. Unfortunately, we can open accounts
that don't have a parent account but can't open the parent account itself. In
essence, we have two accounts with another one the parent - we can open ones
that show the parent, but again, we get an error - see yor administrator. Is
there a rights issue or relational setup we're missing.
...Unable to open Access 95 mdb in Access 97
I am trying to open an old Access 95 mdb in Access 97...I
didn't create it but someone who knew the database way
back when said that a system.mda file was created for
that particular database because it had a lot of personal
info in it.
(I am not familiar with mda files...the database folder
also had a system.ldb file there as well...I deleted that
file...but am unsure why it wasn't closed out to begin
I was able to open Access 97 and repair it...but when I
go to open it in Access 97...I get an Automation
Error...Cannot find VEENLR3.hlp file.
Do you think it may ha...Odd problem with worksheets when opening file
Okay, here's the odd problem that's come up.
When you double click on a excel file, excel opens up, but you can onl
see the toolbars. The grid area looks like a snapshot of whatever you
current background is before the file opened up. If you were showin
your desktop, after the excel file opened, you'd still see your deskto
in the datagrid area.
If you start up a new excel file, then do the File>Open>file name, th
file will open correctly.
This problem happens across users here. Everyone is currently runnin
Any ideas on what causes the problem and any...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.
...Locks up when clicking on links in open web pages
I don't know if I'm posting this in the correct discussion group, and if not,
sorry for the trouble. Could you direct me if I'm wrong?
The issue is that the internet connection locks up if I click on a link or
attempt to print from within an open website. It does not happen each time,
but often enough to make me want to pull my hair! I have to shut down the
connection - the message says it is 'not responding,' and reconnect,
sometimes 2 or 3 times, to be able to use the link from the website.
I have a second laptop, and it doesn't have this problem. ...2007 B2 MSOO has encountered a problem
More often then not when I click to open an email in my inbox I get this MSOO
pop-up with a checkbox, checked telling me MSOO has encountered a problem and
needs to close. Has this been an issue for others and is there a fix.
If you have Adobe Acrobat Pro 6/7 (not the reader), go into Control
Panel, Add/Remove Programs, click change for Adobe Acrobat Pro and
remove the Office & Outlook plugins.
"Jax" <Jax@discussions.microsoft.com> wrote in message
> More of...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...Outlook 2007: When i Save a New Rule outlook Change it automatically...
I have this problem with Outlook 2007. I have 15 e-mails addresses in
my outlook, but i can=B4t create the rules for send all the received
mails to each emails folder.
I want to create a simple rule that move all the e-mail that i get
from "firstname.lastname@example.org" to the folder "Inbox/
email@example.com". When i create the rule, all works fine, i
select the correct e-mail account name, the correct destination
folder, etc... but when I hit the SAVE button in rules window, Outlook
2007 changes the account automatically to another one. Not
automatically...audio notes in Word Notebook
I have recorded an audio file using Word Notebook. I would like to
send the audio file to co-workers but they cannot seem to open it. Any
Are your co-workers using Word 2004? Only Word 2004 can open documents in
Notebook Layout view and use the special features like audio, I think.
However, you could use Tools | Audio Notes | Export audio to get just the
audio file out, I think it comes out as an .mp4
Then send that around, it should be a standard format that most any audio
program can play, far as I know.
On 9/14/06 11:09 AM, "firstname.lastname@example.org" wrote:
> I h...When I open a workbook, another one called Book1 is also opened. W
This Book1 becomes the current book. If I go to Window on the toolbar I can
switch to my correct workbook. Why is this Book1 being opened? I can cure it
by closing Book1, then saving my correct workbook, then closing that one. The
next time I open my workbook, Book1 has disappeared.
Do you mean two different sheets within the same workbook?
> This Book1 becomes the current book. If I go to Window on the toolbar I can
> switch to my correct workbook. Why is this Book1 being opened? I can cure it
> by closing Book1, then saving my correct workbo...Why can't I send email messages with Trial Outlook 2007?
I have a new HP laptop that came with the 60 day trial of Office'07. I
receive email but the send/reply/compose functions are grayed out. I am
certain my settings are correct. Why can't I send email?
What happens when you use the Test Account Settings? What is the exact
error message you get?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, KK asked:
| I have a new HP laptop that came with the 60 day...Putting Excel Charts into a Word document that's getting too big
I am creating a Word document (our Annual Report) in which I will have many
charts and graphs that were created in Excel. Currently, there will be at
least 26 graphs/charts in the document.
In the past, there have apparently been problems with not having enough
space to save the Word document because it gets too big. The document itself
is only about 36 pages, but, as I mentioned, within the 36 pages are at least
26 graphs and charts. I'm looking for a way to copy the graphs/charts into
Excel without it taking so much memory.
One solution we thought of was to only paste the gra...