How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask kanoko Your Own Question

kanoko
kanoko, MS Office Guru
Category: Microsoft Office
Satisfied Customers: 232
Experience:  5+ years of Microsoft Office expertise
65089077
Type Your Microsoft Office Question Here...
kanoko is online now
A new question is answered every 9 seconds

I have an excel file that i am trying to save a pdf. The sheet

Resolved Question:

I have an excel file that i am trying to save a pdf. The sheet has many charts. When I try saving as pdf or converting into pdf (I have adobe acrobat standard XI), the process takes well over 15 minutes and in the end fails to actually create a pdf. What I mean by this is that the pdf that is created, when opened, has no pages and I am told by Adobe that there are no pages. When I remove many of the charts or all of the charts, adobe can create the pdf in a matter of seconds. I have also tried using XPS writer and this has failed too. I have also tried saving as a pdf and this fails as well.

Here is what i'm looking for:
1) Someone who can take the file located at: http://wikisend.com/download/482918/HelpFile.xlsx
2) Retain all the formatting and figure out a way to create one single pdf of all pages in a reasonable time frame (e.g. <2 minutes).
3) If you successfully do #2, I'll need details so I can replicate on my master file which I cannot share.

I have excel 2010 and windows 7 professional.

Additional information: The file is large and there are many formulas and formats. That said, if I remove all the majority of charts and keep the format as is, I can create a pdf absolutely no problem.
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  Molinari replied 2 years ago.
2 minutes may be a stretch, it's a 380 page document....
When you tried making it a pdf, did you do it from within excel?
Customer: replied 2 years ago.

Yes I did it from within excel and outside excel. The file is 191 pages. I just downloaded it again to double check. Not sure why you're seeing 380 pages.

 

Also, I have used microsoft's XS format cleaners on this file just as an FYI.

Expert:  Molinari replied 2 years ago.
My conversion has been going on since 10:15 and it's up to page 151, 380 probably means the number of pdf pages.
Customer: replied 2 years ago.

Ok because everytime i've managed to create any sort of pdf it always lists 191 as the total number of pages at the bottom even if it does not successfully create them. If you print to PDF or use the PDF toolbar, it takes over an hour (as you're seeing) to create the pdf (and it does so successfully). Saving as PDF usually allows for faster pdf creation but in this case it's just all a nightmare.

Expert:  Molinari replied 2 years ago.
What happened when you tried print to pdf?
Customer: replied 2 years ago.

It eventually created the full pdf after an hour and a half (everything was in place and looked great). I just want a way to avoid an hour and a half for each document.

Expert:  Molinari replied 2 years ago.
That's the way I was doing it, you forgot to mention that in the original question, but I should have guessed when you said you tried the XPS writer....
I'll check out some other options.
Expert:  Molinari replied 2 years ago.

I'm not having much luck either finding a fast way, even saving as an xls file didn't speed things up.
I'll opt out in case any other experts have a faster way.....

 

 

 

 

 

 

 

 

 

 

Customer: replied 2 years ago.

Thanks for looking into

Expert:  kanoko replied 2 years ago.
I would be glad to help. I cannot guarantee my method will take under 2 minutes since this ultimately depends on the speed of your computer, but the tool I use that provides the fastest PDF conversion is:

http://www.cutepdf.com/products/cutepdf/writer.asp

But you will also need to configure this tool to make it run fast. After installing, go to Start > control panel > devices and printers. Then right-click 'CuteDF Writer' choose 'Printing Preferences' click the 'Advanced' button and under 'Print Quality' choose the lowest option which should be '72 dpi'.

Then try printing your document from Excel and choose the 'CutePDF Writer' as the printer. Please let me know how long it takes to convert using this method.
Customer: replied 2 years ago.

My settings are already there with adobe acrobat (i've already played with these settings) and unfortunately it did not help. I've used cutepdf as well with no luck.


 


Computer I use has a 3rd generation ivy bridge intel i7 3820QM and 16gigs of RAM.

Expert:  kanoko replied 2 years ago.
http://sourceforge.net/projects/pdfcreator/OK, I would repeat these steps with these two PDF print utilities as well:

http://www.primopdf.com/
http://sourceforge.net/projects/pdfcreator/

each one uses a different imaging engine, so if you have a modern processor like an i7 you may see a considerable speedup if their engine utilizes enhanced instructions.

Still make sure to lower the dpi setting for each. and make sure you choose the correct printer in the print dialog menu in excel.
Customer: replied 2 years ago.

Have tried those in the past as well as tried again. Still not working. Bbefore responding and telling me what to try, could you please try on your end to make sure the solution works. I provided a copy of the file as you'll see in the thread.

Expert:  kanoko replied 2 years ago.
I have done this, but I have a much higher end processor, so this is why my machine is able to perform the operation in 2-4 minutes. There are a few other settings you can change in the Pritner preferences that may speed things up for you.

PostScript Output OPtion -> Optimize for Speed
PostScript Language Level -> 1
Advanced Printing Features -> Disabled
ICM Mehotd -> Disabled

Try confirming these settings on all three PDF printers that I mentioned to see if they improve the speed.

Also, how long are each of them currently taking to complete?
Customer: replied 2 years ago.

They take over 1.5 hours to complete. I will also try with the settings you mentioned above. Could you please let me know specifically what type of machine / process / set up you have? I'm curious to know given you said it's much higher than the one I'm currently using.

Customer: replied 2 years ago.

Tried all of these settings on all three and i'm still stuck in the same place. >1.5 hours per. What processor are you using?

Expert:  kanoko replied 2 years ago.
I have an i7-3930K which is a high-end desktop CPU that retails for $500+. It appears your CPU is a mobile chip primarily used in latops. Are you using a laptop for these PDF scans?

Another option you may want to try is using Google Docs to manage your file. You can upload your Excel file and convert it to Google's format and make the file accessible to anyone online.

Is there a particular reason that this file needs to be in PDF format? would another popular document format be acceptable?
Customer: replied 2 years ago.

Thanks for the response. Yes, I'm using an Alienware m14x which retails for quite a lot and the i7-3820QM, while not the 3930, is still a pretty heavy duty chip. I've also tried doing the pdf off of two other computers (desktops), however, the chips on those are weaker and it takes much longer than the laptop. I'm happy to try using Google Docs to manage the file. Could you please send me the instructions on how to do that?


 


As a side, would you be willing to use something like screenleap (or any other screen sharing service) to show me that you can actually convert to pdf the exact file I provided off of wikisend? If you're willing to do that and can show me you successfully converted, i'll gladly give you a bonus on top.

Expert:  kanoko replied 2 years ago.
Unfortunately we do not allow screen sharing on this site for privacy and security reasons.

To setup the Google Docs option, you will first need a Google account, which you most likely have if you use any of these services: G-Mail, YouTube, Picasa, Android.

Then simply go to 'drive.google.com' and log-in with your account. Then choose the upload button (disk with up arrow). Choose your file and make sure conversion is enabled.

The upload may take a while depending on your internet connection. Afterwards, you can open the document, and enable the share feature, which will allow you to share this file with anyone using the Share link that is provided.
Expert:  kanoko replied 2 years ago.
If my previous solution was able to help you please let me know by using the RATING button.

If not, please let me know what else you are having trouble with.
Expert:  kanoko replied 2 years ago.
Were you able to set up the Google Doc version of Excel file?
Customer: replied 2 years ago.

Hey -- Yeah that was helpful but in the end it'll have to be new hardware in order to be able to print pdfs and actually print the document. You are 100% certain you could create a pdf in 2 to 4 minutes on your machine? If yes, then i'll be upgrading my computer based on what you're saying given it seems to be purely hardware issue. Thanks so much!

Expert:  kanoko replied 2 years ago.
I can't guarantee that it will take 2-4 minutes just by using that processor, since there are many other aspects of the hardware and software that will affect this including but not limited to:

1. Speed of RAM
2. Size of RAM
3. Speed of Hard Drive
4. OS Version (Windows XP is faster than Winodws 7, 8)
5. number of background processes running

Secondly, it doesn't seem econmoical to spend $500+ just to improve the performance of a single operation by a few minutes. Instead I would recommend optimizong your workflow to reduce the time spent converting. A few ideas I have are:

1. Reduce the page count of the Excel file by any means necessary (reduce font size, reduce column and row size, eliminate any duplicate or redundant information)
2. Consider using a different file format (non-PDF) for your conversion. Image based conversion is generally faster.
3. Consider using a cloud based file fromat for creation (like Google Docs) that does not require localized copies to be made and converted.

I say this, because you will most likely encounter performance issues in the future (even with updated hardware) if you don't address these issues first. Is there a reason the Google Docs option will not work for you?
kanoko, MS Office Guru
Category: Microsoft Office
Satisfied Customers: 232
Experience: 5+ years of Microsoft Office expertise
kanoko and 6 other Microsoft Office Specialists are ready to help you
Expert:  kanoko replied 2 years ago.
Please let me know if the previous advice was helpful, or if you still ahve any questions about a solution.

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 
Chat Now With A Microsoft Office Technician
kanoko
kanoko
2 Satisfied Customers
5+ years of Microsoft Office expertise