Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export to Excel, then illegal operation when printing

Status
Not open for further replies.
troyu

troyu

Programmer
Nov 21, 2000
185
0
0
CA
1) Schedule a report to run on Seagate Info.
2) Export the report into Excel.
3) When trying to print from Excel, receive "Illegal Operation" message.
* User has Windows 95, Seagate Info 7.
* Printing to an HP printer.

When I try and print the exact same Excel file on my Windows 95 and 2000 machine, it prints fine. No errors. Any ideas, however vague? Looking for help!
 
Sort by date Sort by votes
If you save it in Excel, close and reopen it, does it still error on that PC?

Does the size of the spreadsheet matter?
Does the PC that works have INFO installed?
Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Upvote 0 Downvote
1) Yes, the error still appears if we close and re-open the file.
2) No, the size of the spreadsheet does not matter. The error is just occuring on this report however. Other reports exported to Excel work ok. Just not this one
3) Both PC's have Seagate INFO 7.0 installed.
 
Upvote 0 Downvote
Someone may know exactly what this is, but I would start deleting objects from the report until the problem stops, to identify the cause. Starting with anything unique about this report. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Upvote 0 Downvote
Anyone else have any feedback?
 
Upvote 0 Downvote
I had a very similar problem using Info 7 and exporting to Excel. We were never able to figure out exactly what was going on, but we were able to get around it by checking the "No Printer" option in the File|Printer Setup menu before running and exporting the report. We thought it might be when a Crystal report has a default printer set, and someone tries to print on a computer with a different default printer using Excel, it gives the error. We now design all of our reports that get exported to Excel with the "No Printer" option checked, and the problem has gone away.
 
Upvote 0 Downvote
Upgrading from Seagate Info 7.0 to 7.5 appears to have resolved the problem.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
90
SoftwareRT
SoftwareRT
Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
71
hilfy
hilfy
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
143
hilfy
hilfy
vadnagra
  • Locked
  • Question
Crystal reports Export to Excel
Replies
1
Views
71
lbass
lbass
BradCustom
  • Locked
  • Question
Connect to Excel Spreadsheet
Replies
2
Views
85
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top