I've made rounds on this already and can find no fix on any forum I know, though there are some similar posts.
I have this legacy database in Excel that indexes values from many tables and posts them into cells on a report sheet that has an image of a scanned paper form. The image is transparent, so the cell values show through in the right spots on the form. The form is printed and sent to agencies. There are many such forms in the Excel file. It has worked perfectly in Excel 2003, but now I'm on the 2007 version. Still running XP. Not my decision; can't revert back; can't get Vista. So, the problem is, the form prints illegibly fuzzy now. I've tried to print it from other PCs and Macs with Excel 2007, on several printers. If I save it back to the old version I lose all the functionality I've added, a lot of stuff doesn't work, but I can print the form on my home PC using Excel 2003 in Win XP and it looks fine.
Things I've tried:
Resampling the image and inserting in other image formats,
Testing the image using Word and PowerPoint instead of Excel,
Fussing with printer and page settings,
Reseting the print area to only the form,
Changing Excel options for resolution and display,
Updating my printer drivers,
Trying my home printer on my PC at work,
Trying my work printer on my PC at home,
Inserting the image in as a rectangle fill,
Inserting the image as a background,
Calling Microsoft tech support in India.
Nothing has helped; the print results are exactly the same unless I print using Excel 2003 in Win XP. This worked using my work printer at home, too, so it's not the printer or printer driver.
This seems to be a downgrade in Excel 2007's rendering method. I haven't been able to try Excel 2003 in Vista, so maybe the problem is Vista's rendering for Office 2007 is fine and XP rendering for Office 2003 is fine, but Office 2007 doesn't play well with XP? I'm guessing here.
Anyone?
I have this legacy database in Excel that indexes values from many tables and posts them into cells on a report sheet that has an image of a scanned paper form. The image is transparent, so the cell values show through in the right spots on the form. The form is printed and sent to agencies. There are many such forms in the Excel file. It has worked perfectly in Excel 2003, but now I'm on the 2007 version. Still running XP. Not my decision; can't revert back; can't get Vista. So, the problem is, the form prints illegibly fuzzy now. I've tried to print it from other PCs and Macs with Excel 2007, on several printers. If I save it back to the old version I lose all the functionality I've added, a lot of stuff doesn't work, but I can print the form on my home PC using Excel 2003 in Win XP and it looks fine.
Things I've tried:
Resampling the image and inserting in other image formats,
Testing the image using Word and PowerPoint instead of Excel,
Fussing with printer and page settings,
Reseting the print area to only the form,
Changing Excel options for resolution and display,
Updating my printer drivers,
Trying my home printer on my PC at work,
Trying my work printer on my PC at home,
Inserting the image in as a rectangle fill,
Inserting the image as a background,
Calling Microsoft tech support in India.
Nothing has helped; the print results are exactly the same unless I print using Excel 2003 in Win XP. This worked using my work printer at home, too, so it's not the printer or printer driver.
This seems to be a downgrade in Excel 2007's rendering method. I haven't been able to try Excel 2003 in Vista, so maybe the problem is Vista's rendering for Office 2007 is fine and XP rendering for Office 2003 is fine, but Office 2007 doesn't play well with XP? I'm guessing here.
Anyone?