Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...how do I add times in Excel and result in hours & mins
I want to insert a time when I start work and a time when I take a break,
then a time when I leave work.
Following that I want to be able to add up the amount of hours that I have
This will enable me to plan my week ahead and ensure I only allocate a
specific amount of time to a project.
Microsoft MVP - Excel
"Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message
>I want to insert a time when I start work and...Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty sheet or none.
So, form MS Access's VBA I'd like to do:
On Error Resume Next
On Erro...problem with signature
I am trying to create a simple signature for my HTML mails, with a link to
my website.I want it to be a hover link, no underline.
I have made a very simple HTML in Dreamweaver, and all the appropriate
attributes and styles are set via CSS. It looks and works fine on my
But when I select it as my signature file in OL2003, hover link property
disappears and it reverts to the dreaded underline link.
Any ideas how achieve this?
...subtracting columns in a macro
I'm trying to subtract columns in a macro, but since the
resulting file will be exported in *.csv format, I only
want to subtract the rows that have data in them. Can
someone tell me how to do that?
Thanks so much!
...Opening a new instance of Excel
I am using multiple monitors for work and it is great! Is
there a setting that I can use so that it opens each new
excel file in a new excel window so I can drag different
ones to each monitor? Is there a similar setting for Word?
I am using Excel 2002 and Word 2002.
Yes, you can check the Windows in Taskbar checkbox in
Tools; Options. This is on the View tab for both Word
>I am using multiple monitors for work and it is great!
>there a setting that I can use so that it opens each new
>excel file in a new excel ...Word Attachment problem
Have a network of PC's with MS Office of various flavours, drawing
Email from Exchange Server.
On one PC, have had an ongoing problem with Word attachments.
PC has ben reformatted, permissions opened up to Admin, Office
upgraded, from 2000 through XP to 2003 all with the same result.
When you double click on a Word attachment and chosse to open it, you
get a 'Serious error' report with the option to restart Word. Sometimes
this works other times it just loops through the same.
The latest update to Office 2003, when using the 'Send Report' and then
using the diagnosis fro...Emailing in excel 2003 02-26-10
If i type in the cell A34: neil.Holden@test.com and press a button is it
possible to email to the address of what ever is in A34 is?
The email body should say: this has been submitted for cell B34 and todays
Check out Ron De Bruins "Send-Mail" tips:
"Neil Holden" wrote:
> If i type in the cell A34: neil.Holden@test.com and press a button is it
> possible to email to the address of what ever is in A34 is?
> The email body should say: this has been submitted for cell B34 and...Outlook2k7 over VPN Out of Office Assistant problem
User's computer is not a member of the domain. Mail flows and all
looks good till you start the OOF thing. It will just tell you it
cannot connect to the server because it's currently unavailable. Now
when we add autodiscover.domain.com pointing to the Exchange server to
the host file of that computer it works but why? Without it when you
run a test it will tell you that a Srv Record lookup for domain.com
FAILED (0x8004010F) or Local autodiscover for domain.com FAILED
Thanks for your post.
The error 0x8004010F usually means MAPI_E_NOT_FOU...Money '04
I'm trying to use the 'Money Browser' w/in MSN Money 2004
and get "Page Cannot Be Displayed" or sometimes "Action
Cancelled", but I can surf the web just fine with my
cable modem...what's up with that? I've read on this
forum that other users are having difficulties w/ this
particular issue, any resolution would be helpful. I've
regsvr32 msxml3.dll in start|run
also have un-installed and re-installed
...Formula help... #3
In column A there are cells with team names in them like the following:
I would like column B to list all the team names without the @ symbol and
column H to list all the teams with the @ symbol. For the example I would
like column B to have
(remove nothere from the email address if mailing direct)
"Jambruins" <Jambruins@discussions.microsoft.com> wrote in message
news:135965C4-7523-47AB-88DE-D0B12B652CD5@m...Outlook Mobile Access Problem
Hi I've a big problem in Outlook Mobile Access.
I've a server exchange standalone withoput a front-end=20
I've configured the OWA web form authentication and SSL.
For OWA it's all right...everything is going right...
The problem is OMA
When I try to log on on oma I find the following error=20
message :"Unable to connect to your mailbox"
To solve my problem I've found in microsoft web site the=20
Microsoft Knowledge Base - 817379
Cannot Access Exchange Server 2003 by Using Outlook Mobile=20
Access When the
Exchange Virtual Directory Require...Macro must return the name of the button
I want to a macro to display the name of the button (or object) from where I
am calling that macro. Anyone an idea?
What sort of button (userform, worksheet forms, worksheet control toolbox)?
(remove xxx from email address if mailing direct)
"Derek Brussels" <Derek Brussels@discussions.microsoft.com> wrote in message
> Hi there,
> I want to a macro to display the name of the button (or object) from where
> am calling that macro. Anyone an idea?
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
...Does anyone have a dashboard gauge (speedometer style) for Excel?
I am trying to create dashboard charts from Excel data and would love other
templates not available in Excel today - speedometer charts, multi-dimension
comparitive charts, charts that build information overlays.
I regularly create these in a manual way for executive and customer
summaries but would appreciate the ability to automatically generate these
types of charts allowing for real time viewing of "what if" scenarios.
Steve, there are tons of these things out there to review, few better than
Andy Pope has put together...Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <email@example.com>,
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.
...outlook 2000 help file
Seems after I did added SP3 from MS upgrade site my help from outlook has
quit working. message is msohelp caused error in itss.dll. help works in ALL
other programs including outlook address book. I'm running windows 98 SE,
Office 2000 SB and IE 6.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/03
...EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...OWA problems #6
Users from outside the firewall can logon succesfully into OWA interface,
their mailbox opens, but in the reading pane the only message is "loading..."
Also no other functions of OWA interface seems to work (new, contacts...) as
well as log off button.
However if I try to access OWA from inside the company everything is fine.
Windows 2000 Server SP4
Exchange 2003 SP1
On Thu, 6 Oct 2005 11:33:14 -0700, "Ducukm0"
>Users from outside the firewall can logon succesfully into OWA interface,
>their mailbox opens, but in t...macros disabled
I've just upgraded to Office 2007. Now, when I tried to run a program, it
says, "The macros in this project are disabled." What to do?
I've got it. It was due to the "Missing" references. Mr. Chip Pearson helped
identify the problem.
> I've just upgraded to Office 2007. Now, when I tried to run a program, it
> says, "The macros in this project are disabled." What to do?
Just as with 2003 you need to enable macros. But, unless the VBIDE is open,
How do I get my X axis and Y axis to auto scale inside my chart when I add
new data in my spreadsheet?
"Sandi" <Sandi@discussions.microsoft.com> wrote in message
> How do I get my X axis and Y axis to auto scale inside my chart when I add
> new data in my spreadsheet?
The default is to do so.
Check Format Axis/ Scale, and ensure that Auto is ticked for Min & Max.
That works for my Y axis but I also need my X axis to auto scale also.
"David B...In Excel program shows a broken line and don't know how to get ri.
I am trying to put in entries in Excel program and when I go to Print
Preview, it only shows part of the entries I put in. When I go to the last
entry that it shows in Print Preview, there is a broken line between it and
the next entry. I don't know what I did. I could use some help
You probably have multiple areas selected for your print area.
you can check this by <view><page break preview>
One possibility to correct this would be
<file><print area><clear print area>
or specifically select the area you want printed and
<file ><Print area>...Excel Cells Contents to HTML Pages
I have an excel sheet which has two columns.
Column 1: PageName
Column 2: HTMLCode
PageName has information like: OurServices.htm which is the name of th
HTMLCode clumn has actual HTML Code like:
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html
charset=windows-1252"> ...How to realize communication problem?
I am working on a project in which I read/write data via rs-232 from/to my
Windows application to/from an microcontroller.
Now, my boss wants me to write a library which he can use for different
microcontrollers. This library should store any changes of data. So the
desired microcontroller should just be able to pick up the data.
You can think of it this way: Me, representing the Windows application, put
a sheet of information into a drawer. A buddy of mine, (representing a
microcontroller) can go to the drawer an pick up the sheet for further
So, my quest...