1 person found this helpful
The error is vague, but from your reply the detail would not help you at all. The file has an error at the very lowest level of internal stuff - this is nothing to do with your Excel file, though it could possibly be a marginally corrupt graphic passed through. It's that or a bug in the PDF creator.
This is a community forum. Perhaps you could point at a file on your web site for others to pick apart.
Thanks for the offer of help.
Here is the file (edited to remove client info).
To fill out the story a little more, the error seems to go away with Acrobat v10 (or whatever is the latest).
However, what is not acceptable is that some of my clients cannot even see the text in the pdf - just the background graphic.
Ok, I've done some research. Here are my thoughts.
1. The error message, anything like that is a Red Flag. Don't think of distributing a file with that kind of error. Different software, and even different releases of Acrobat will do different things. Some will show the page up to the error. Some will blank it out. Some will show the page, then blank it if you try to scroll. And so on.
2. The problem is that the PDF is bad. The Bad Thing happens to be the last thing in the page, and not part of what you designed (I expect), so you might see everything else - but that's just good luck.
3. You export the file from Excel. This what is doing the bad stuff. Try using the Acrobat toolbar in Excel, or printing to Adobe PDF.
4. Technical details: the problem is that Excel includes two grey boxes scaled to 0%. 0% is an impossible size and causes errors. Maybe you added these boxes yourself - if so, you can remove them. The chances are it's just something Excel does, maybe there's an update.
It does indicate that you used the MS add in as and export from Excel. The best solution is probably to print to the Adobe PDF printer to create the file. As usual, MS tends to mess up conversion software. Unfortunately, they also seem to try to put hooks in stuff that gets sent to the Adobe PDF printer, but the end result may likely be better when you print. In addition, your fonts are not embedded in the file. You can also print the current PDF to a new PDF or use
Just as a test, I used an embed font fix-up from the preflight options. I then closed and reopened the file. I got no error on the reopening. The bottom line may be just the PDF creation process from MS. I suspect the creation does not meet the PDF standard. MS had the same problem with trying to change HTML. However, in this case the PDF is an accepted standard and is defined by Adobe.
Thaks very much - no it didn't put the impossible box in the document.....
Thanks, I'll try to get my hands on a pdf writer...
Sounds like you are using Reader, not Acrobat. Reader is a different forum. That may be why we were wondering why you were creating the PDF by and export from Excel. Acrobat would normally be used for this job. If you do not have Acrobat and are not in the position to pay for it, then there are several free creation tools that do a reasonable job of creating PDFs.
Yes, but I do now have a pdf printer driver - and it solves the problem!