Office Equipment & Supplies Logo

Related Topics:

Dena Canaguier Posted on Mar 27, 2007

Using Job Accounting with Excel

We have several Canon copiers on campus that we would like to print to. We have job accounting on all copiers. This works well when printing from all software applications except Excel. When we try to print multiple copies from Excel it asks for the copy code for every copy. For example, if I want to print 50 copies of something in Word, I put my code in one time and it prints 50 copies. If I want to print 50 copies in Excel, I have to put in my code 50 times. Not very convenient. Is there any way to fix this? I have search help in excel and nothing addresses this. Thanks. Dena

1 Answer

Anonymous

Level 1:

An expert who has achieved level 1.

  • Contributor 1 Answer
  • Posted on Nov 19, 2007
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

Joined: Nov 19, 2007
Answers
1
Questions
0
Helped
189
Points
2

Try unticking the collate box on the print window. this can cause 50 jobs to be sent rather than 50 copies of the same job.

Hope this helps

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

What could be the problem when Xerox workcenter 5335 shows " A system error has occurred." error o16-322

The accumulated accounting data in Job Based Accounting reached the specified value.
  • Switch the power off then on 2 minutes after the job is attempted (after an external Accounting Server has read the accounting data).
  • If the problem persists, have the customer perform a manual retrieval of machine data from their Accounting server.
  • If the problem persists, perform Initialize Hard Disk and then have the customer push the User Accounts to the machine from their Accounting server.
  • Ensure that the customer is programming a job within the parameters of the machine utilizing the UI.
0helpful
1answer

I have Kyocer KM-1650. i have employed someone and am not trusting the guy.i need steps to set up the job accounting passward.

Hi,
Press System Menu / Counter.
Press down arrow and select Job Accounting by pressing Enter.
Enter Admin Pin Code - 1600
Press down arrow to Edit Job Accounting.
Press Enter.
Press down arrow to New Registration.
Enter pin code.

To Switch Job Accounting on:
Press System Menu / Counter.
Press down arrow and select Job Accounting by pressing Enter.
Enter Admin Pin Code - 1600
Press down arrow to Accounting On/Off and press Enter.
Press down arrow to on and press Enter.
Press Reset. (Yellow Button)
ID Code Screen will appear.
3helpful
1answer

016-757

This Problem is related with Accounting. You might be trying to print a job to a 7345 which has accounting enabled and you dont have your driver configured to sent the accounting information.
After getting and Accounting ID please go to Printer
0helpful
1answer

Radio Shack Oki C6100 does not print color... only greyscale. Solution on your site might work on another operating system, but the suggested fix is to download a utility called "English Job Accounting...

I'm not familiar with this printer, but my Samsung colour laser has an option in the driver for choosing 'color' or 'grayscale' - make sure it's not something as basic as that for starters.
0helpful
1answer

Already we connected the ir3300 machine through network.now we want a weakly printing log for every weak.how can i do this?

You can try turning on DepID management. This will not separate photocopying and printing but it will allow you to record how much has been printed for each job/client. Make sure you have Job Accounting turned on in the print preferences/properties (can't remember which) if using this method. Then remember to print the total off each week and clear the totals on the machine.

Alternatively if you want detailed logs (e.g. info on each item printed, can't do this for photocopying I'm afraid) then print charging software such as PaperCut could be useful for you. I currently use the free version of that software (free for 5 users or less). This will provide detailed logs down to every job, what kind of paper was used, b&w/colour and will allow different costs/prices to be set for different size paper, b&w and colour etc. You install PaperCut on the server and share the printer from your server and install the client on each machine.
0helpful
1answer

When i print online, copier counter does not give me print count as per 'Department Code'. I want to setup on-line printing with individual 'department codes'. THIS MACHINE IS CONNECTED WITH WINDOWS VISTA...

if you have the codes in the copiers allready you need to turn job accounting on in the print driver settings find copier under your pronters and faxes right click on it select properties then i believe under the device settings you have to check job accounting then enter the id code
0helpful
1answer

Problem getting a Vista OS computer to see the copier on a network

Make sure there are no firewalls turned on any desktop.  Firewall control should be turned on the router only.
Windows Explorer has some bugs in their browsers that may not work on certain copiers.  It is best to use Firefox or Safari instead to do any administration work on your copier. 
0helpful
1answer

Printing seperate account totals from copier

Press System/menu counter
Scroll down to User/Job accounting
Press Enter
Scroll down to job account set
Press Enter
Scroll down to Account Report
Press Enter
Select Yes
The Job accounting report is printed.
0helpful
1answer

MAC problem with km-3050

What MAC OS are you using? I don't remember for OS 9 and earlier but if you are using OS X I can help you out. First make sure you are using the latest version of the print driver. When you open a document to print and select the Kyocera printer you will see the print dialog box. You need to look under the printer specific options to find the job accounting. I believe it is under set 2.

Hope this helps.

Henry
Not finding what you are looking for?

199 views

Ask a Question

Usually answered in minutes!

Top Canon Office Equipment & Supplies Experts

old marine
old marine

Level 3 Expert

2426 Answers

ZJ Limited
ZJ Limited

Level 3 Expert

17989 Answers

Cindy Wells

Level 3 Expert

6688 Answers

Are you a Canon Office Equipment and Supply Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...