I have created an excel report by running a macro on my machine. When i view the report on my machine it displays the page breaks properly but when the same report is opened on a friends computer it shows improper page breaks. It takes 9 pages on my machine and 14 pages on my friends machine, out of these 14 pages some pages are blank with header and footer. I have tried adjusting manually but I want some permanent solution and I guess there is some printer driver settings which affect pagebreaks.
note: i ran the macro for the report on excel 2007, saved in 2003 format after running and then opened in excel 2003..
Bookmarks