Solved

Windows Explorer - Print Excel File (Any File Type)

Posted on 2013-01-10
5
300 Views
Last Modified: 2013-01-15
I have a customer that prints files through Windows Explorer on a routine basis.  The process is:

Right Click File (Excel file for this example-cant see that this is issue specific to Excel though)
Print
-->The file then prints and she goes to another file in a different folder and repeats the process

She is pretty quick at it so the process is going rather fast.  The new issue is certain spreadsheets, when she right clicks and chooses print will open the file and ask her if she wants to save the file or not.  She is clicking no and then goes to  the next.  The spreashseet that prompts her to save and the ones that done appear to  be identical.  What would cause one to prompt saving the file and others not to.  

Notes:  Only ten files out of probably a thousand are causing this.  All files are in different folders.
0
Comment
Question by:twomacsfour
5 Comments
 
LVL 38

Expert Comment

by:BillDL
ID: 38766462
What operating system is in use on the computer in question?
What version of MS Office is installed on that computer?

I assume that the user is aware of the various extensions that can be applied to "Excel" files, and would notice if it was one particular extension that was behaving this way?
eg. Templates: xlt, xlthtml, xltm, xltx and the non-template equivalents xls, xlshtml, xlsm, xlsx

Is the user accessing these files from a shared drive, or from her own computer's hard drive?

Has the Read-Only attribute been eliminated from consideration?

My thoughts are that perhaps the handful of files that prompt to save are Excel 2007 and above (xlsx) and are having to be converted when printed through Excel 2003 and earlier, or they are templates.
0
 
LVL 94

Accepted Solution

by:
John Hurst earned 475 total points
ID: 38766938
Do some of the files have an active date or some similar formula?   I have spreadsheets with =NOW() as a date formula. These worksheets always ask me if I want to save or not, even if I merely open the sheet and do nothing. This has been true forever with Excel.

.... Thinkpads_User
0
 
LVL 45

Expert Comment

by:aikimark
ID: 38773422
If this is the same set of files, have you tried using a batch file to invoke the printing?
0
 

Author Closing Comment

by:twomacsfour
ID: 38780147
At the very bottom in the far right hand corner of the spreadsheet was a cell that updated every the time every second.  

Thanks for your help
0
 
LVL 94

Expert Comment

by:John Hurst
ID: 38780212
@twomacsfour - Thank you and thanks for the update.

.... Thinkpads_User
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
This collection of functions covers all the normal rounding methods of just about any numeric value.
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question