Excel 2003 Wants to Print to File (not checke

Microsoft Office 2003 student and teache...
June 13, 2010 at 07:50:12
Specs: Windows 7
Running Windows 7, Excel wants to print (new and existing) files "Print to File", even though "Print to File" is NOT checked. Printer is new CanonMX860. Other apps (incl Word, web pages, etc) print fine. Didn't have issue with other (HP,Lexmark)printers. CAnon says not printer issue since other apps print. Ideas? Thanks.

See More: Excel 2003 Wants to Print to File (not checke

Report •


#1
June 13, 2010 at 08:19:28
Try this first:

Running Microsoft Office Diagnostics from within Excel

Click the Microsoft Office button

Click on the Excel Options button to bring up the Excel Options dialog box

Click on the Resources button in the left hand pane

Click on the Diagnose button in the right hand pane

Click Continue

Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button

Click All Programs

Click Microsoft Office folder

Click Microsoft Office Tools

Click Microsoft Office Diagnostics

Click Continue

Click Run Diagnostics


See if that is of any help.

MIKE

http://www.skeptic.com/


Report •

#2
June 16, 2010 at 18:16:18
I don't see this in Office/Excel 2003....

Report •

#3
June 16, 2010 at 18:25:55
OPPS, that's for 2007,
for 2003,

On the Task Bar
Help
Detect & Repair

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
June 17, 2010 at 13:03:01
Thanks for the follow-up. I did as you suggested; still have the problem. It comes up with a small print window (typical) that says: "Now Printing 'File Name' on "Name of Printer" on FILE".

Second pop-up window called "Print to File" is asking for "Output File Name"

Thanks again for trying to help.....


Report •

#5
June 17, 2010 at 13:28:01
Try starting in SAFE Mode:

Click START
click Run

Enter: excel /s

If you get an error message, you may have to use the complete path, something like:

C:\Program Files\Microsoft Office\Office\Excel.exe /s

Safe Mode forces Excel to bypass:

All files in any Excel startup folder.

Add-ins: The Addins dialog box still displays the
selected addins, but, the addins are not loaded.

Excel toolbars (Excel.xlb or <username>.xlb): The
original installation default toolbar settings are used.

Excel specific registry information: The original
installation default registry settings are used.

If this solves your problem, then the culprit resides somewhere in the above locations.

MIKE

http://www.skeptic.com/


Report •

#6
June 25, 2010 at 08:52:10
Thanks. Tried your suggestion for safe mode. Tried to print, but same result as before (print to file came up). So, still seaching for a solution.........

I would buy Office 2010 if I was 100% certain that it would solve the problem.


Report •

#7
June 25, 2010 at 15:40:38
Only other suggestion is to try Unregservr & Regserver

First close Excel
Click Start
Click Run

Type: excel /unregserver

then

Click Start
Click Run

Type: excel /regserver

The /unregserver & /regserver commands resets the windows registry to excel's factory defaults.

MIKE

http://www.skeptic.com/


Report •

#8
June 26, 2010 at 05:58:09
Hi,

Have you been able to connect another printer to see if the problem is specific to the Excel/Cannon MX860 combination.

If another printer works normally with Excel, then the problem would appear to be specific to the combination.

A Google search reveals that a few others have reported this issue with the same printer and Excel 2003. It was not clear if the problem only occurred when the combination included W7 as the OS.

As a result, I suspect that no amount of reinstalling/repairing Excel will help.

I don't know if there is an updated printer driver available - may be worth a search.

Also I don't know if the problem exists with later versions of Excel. Given that the posts I saw referred to Excel 2003, it is possible that later versions are OK. One post noted that Excel 2000 worked OK, but that could be due to it running on a different OS.

Regards


Report •

#9
June 28, 2010 at 07:29:13
Tried the latest suggestions -- same issue. Ran "compatibility" from shortcut (right click). Eventually it came up w/"missing library/object stdole32.tlb." Uninstalled and reinstalled Office 03. No difference; ran "compatibility" again and it eventaully (after report to Microsoft..") that Excel is incompatible (it didn't say with what).

I did put the Canon MX860 driver on my "back-up" laptop that runs Vista; Excel prints from that one ok.

Other thoughts?


Report •

#10
June 28, 2010 at 08:22:47
Hi,

I did put the Canon MX860 driver on my "back-up" laptop that runs Vista; Excel prints from that one ok.

This suggests that the problem is very specific to Windows 7 with Excel and the Canon MX860 printer driver.

Are your Windows 7 PC and backup laptop networked - if so share the MX860 printer on the Laptop and access it as a shared printer on the W7 PC. It might work, although it probably still loads a W7 driver on the W7PC - worth a try.

If all else fails - you could keep the 'Print to File' and send the file to the printer.
Here is a link to a small utility that makes it easy to send the file to the printer: Print File

Regards


Report •

#11
September 4, 2010 at 23:42:26
I have several Win7-64 machines, all using Excel 2003, all sharing the same MX860 on a network. Some of them work, some of them suffer from this exact same problem - everything but Excel prints just fine, and Excel wants to print to a FILE.

The weird thing is, some machines work just fine, and are otherwise very similar from both an OS and application software perspective. So it's not just purely a Win7-Excel2003-MX860 doesn't work issue.

The solution to this (although only a temporary one) is to select any other printer from the printer list (even a fax machine), then select the MX860 again, and it prints just fine. However, I have to re-do this workaround everytime I close and then re-open Excel.


Report •

#12
September 5, 2010 at 07:00:37
Hi,

Why not make a macro that runs every time Excel starts.
Personal.xls is a hidden workbook that is normally opened every time Excel starts.
In the VBA window, (use Alt + f11 to open it), find VBAProject (PERSONAL.XLS) in the Project explorer pane. Double click 'This Workbook' and enter this code:

Private Sub Workbook_Open()
'routine to set the default printer to a known printer
'then set it back to the Cannon MX printer
'change printer names to match your known printers.
SetDefaultPrinter ("Fax")
SetDefaultPrinter ("Canon MX860")
End Sub

Check that the names exactly match those on the PC

Go back to the Project explorer pane, right-click on 'ThisWorkbook' and select 'Insert' and 'Module' (not Class Module)
Double click the new module - typically Module1, in the Modules Folder.

The following code is pasted into the VB window:
(This code was not written by me - I just pared it down to what's needed in this case. The code comes from faq705-5479 on www.tek-tips.com.

Option Explicit

'Declarations
Private Declare Function GetProfileString Lib "kernel32" _
                 Alias "GetProfileStringA" _
                (ByVal lpAppName As String, _
                 ByVal lpKeyName As String, _
                 ByVal lpDefault As String, _
                 ByVal lpReturnedString As String, _
                 ByVal nSize As Long) _
                 As Long
Private Declare Function WriteProfileString Lib "kernel32" _
                 Alias "WriteProfileStringA" _
                (ByVal lpszSection As String, _
                 ByVal lpszKeyName As String, _
                 ByVal lpszString As String) _
                 As Long

Function SetDefaultPrinter( _
            strPrinterName As String) _
            As Boolean
Dim strDeviceLine As String
Dim strBuffer     As String
Dim lngbuf        As Long

' get the full device string
strBuffer = Space(1024)
lngbuf = GetProfileString("PrinterPorts", strPrinterName, "", _
            strBuffer, Len(strBuffer))
 'Write out this new printer information in
' WIN.INI file for DEVICE item
If lngbuf > 0 Then
    strDeviceLine = strPrinterName & "," & _
                        fstrDField(strBuffer, Chr(0), 1) & "," & _
                        fstrDField(strBuffer, Chr(0), 2)
    Call WriteProfileString("windows", "Device", strDeviceLine)
    SetDefaultPrinter = True
    Else
    SetDefaultPrinter = False
End If
End Function

Private Function fstrDField( _
                mytext As String, _
                delim As String, _
                groupnum As Integer) _
                As String
' this is a standard delimiter routine that every developer I know has.
Dim startpos As Integer, endpos As Integer
Dim groupptr As Integer, chptr As Integer
chptr = 1
startpos = 0
For groupptr = 1 To groupnum - 1
    chptr = InStr(chptr, mytext, delim)
    If chptr = 0 Then
        fstrDField = ""
        Exit Function
    Else
        chptr = chptr + 1
End If
Next groupptr
startpos = chptr
endpos = InStr(startpos + 1, mytext, delim)
If endpos = 0 Then
    endpos = Len(mytext) + 1
End If
fstrDField = Mid$(mytext, startpos, endpos - startpos)
End Function

I can't test that this will work for you, so it's a bit of a guess - but might be worth a go.

Regards


Report •

#13
September 16, 2010 at 13:37:51
Hi all, had the same problem Win 7 64bit, Excel 2003 would only print to file on a Canon MX850.

I solved this on my system when I noticed that if you point at the printer in the Network menu, and right click there is an option to install drivers ( even though I had installed all the drivers and everything was working except Excel 2003 ).

Anyway I thought no harm in trying so pressed the option, drivers installed and hey presto I can print from Excel 2003 without the messing about changing printers partial fix.

Hope this helps.


Report •

#14
October 25, 2010 at 08:17:40
I had the same problem with excel 2003/win7 64 and a Canon MP620 networked printer. Sparky's fix worked!

Report •

#15
November 21, 2010 at 09:33:33
I had the same issue with MS WORD 2007 in the Windows 7 environment. Trying to print to a printer but it kept kicking me to print to a file. I loaded my printer after trying to print a doc from word. I have loaded the same printer countless times in XP with no issues. A particular screen came up during my Windows 7 load. I should have noted what the screen said but I did not however it dealt with ports. I can say that it paused my driver loading until I clicked my way thru it. I thought I picked the best setting but I did not. To keep it short the fix was to go to control panel, select devices and printers, right click the printer and select printer properties. Then select the ports tab and chose the port with the description of network printer port. All worked great after that. One side note is that my computer location was set to PUBLIC during printer driver load, I changed it to HOME during my troubleshooting.

Report •

#16
December 17, 2010 at 23:03:10
To SparkyGaz: Thank you in advance for sharing your tech know-how to solve this issue with Excel. I'm still running WinXP, Excel 2003, using Canon mp620 on a network. Everything else prints without a problem except Excel. What's interesting is printing an Excel file from another computer works, so I'm at a loss.

How do I apply your fix to my system? It seemed that daves1234's problem with his Canon mp620 was resolved following your advise. Please help!


Report •

#17
December 22, 2010 at 05:29:34
Yes! Finally found a solution to that nasty problem (Excel + Win7 + Canon MP620 in my case). Thanks SparkyGaz. Did just that: open the network page, right clicked on the printer and ran "Install". This created a second printer (MP620 WS) next to the first (MP620). Still using the first as default printer, as the WS version doesn't seen to work, but now works from Excel and all other apps with the normal printer.
Great!

Report •

#18
December 23, 2010 at 03:00:23
Sparky's fix also works for WIN7/Excel 2003 and a Canon MP620!
Thanks a lot!

Report •

#19
December 27, 2010 at 08:23:52
Great Guys This damned trouble is fixed but I double clicked on the printer logo on the network instead, (nothing available on right clic). The drivers from the printer start to install even if I did it before from lastest Canon website. And then Excel start to print normally.
Thanks a lot

Report •

Ask Question