I saw a thread that contained this question, but the responses did not resolve the issue, so I am posting again.
I have Acrobat 6.0 on three computers. 2 of these computers can create PDFs from Excel with no problem, one cannot. On this one, just as in the other thread, a black box is placed over some or all of the cells in the spreadsheet.
The one computer runs Office 2003, while the 2 run Office XP, so I thought that might be an issue. However, I created a spreadsheet with Excel 2003 and one simple line in cell A1 and it still blacked out the cell in the resulting PDF.
I removed Adobe Reader from the machine hoping that was a problem. No change in the black cells.
I upgraded to 6.0.2 - no difference.
I tried both creating the PDF from Excel, and from Acrobat itself. The problem persisted.
I tried using the Print to PDF in Excel and that worked - no black box, which is where the other thread and I vary; JG_Howard did not have successful results with the Print to PDF function.
So I have a work around, but I still want to know why it is doing this. Does anyone have any ideas? I have surfed and surfed and only found JG_Howards abandoned thread.