S
stan-the-man
I have a wide excel data document and I want to print it on one page of 11 x
14 paper. (landscape)
In Excel 2003 this is not a problem. I go into page setup and set the
scaling to fit to one page wide by one page tall and it scales to fit exactly
as needed. No problem.
In Excel 2007 I do the same thing, set the scaling to fit to one page wide
by one page tall and it goes bonkers. Instead of consolidating the data onto
one page, it page breaks into 30 pages with bizaar margin settings I did not
choose, the font size stays at 100% on the print file itself, it is quite a
twilight zone experience to say the least.
I have found one work-around on this from a blog on the net. I was told to
go into c:\program files\microsoft office\office12 and delete EXCEL.EXE
Once I launch Excel again from the start menu (the shortcut from quick
launch will not work (if applicable) as it is pointing to the program just
deleted) - I will see Excel install and voila! no more issues with print
preview.
This should not be a permanent solution for this issue. Excel 2007
programmers need to come up with a fix that will permanently fix this issue,
otherwise, I foresee that I will have to delete and reinstall Excel 2007
every time I want to scale a print job to a reduced size.
Need some help here people. Thanks,
14 paper. (landscape)
In Excel 2003 this is not a problem. I go into page setup and set the
scaling to fit to one page wide by one page tall and it scales to fit exactly
as needed. No problem.
In Excel 2007 I do the same thing, set the scaling to fit to one page wide
by one page tall and it goes bonkers. Instead of consolidating the data onto
one page, it page breaks into 30 pages with bizaar margin settings I did not
choose, the font size stays at 100% on the print file itself, it is quite a
twilight zone experience to say the least.
I have found one work-around on this from a blog on the net. I was told to
go into c:\program files\microsoft office\office12 and delete EXCEL.EXE
Once I launch Excel again from the start menu (the shortcut from quick
launch will not work (if applicable) as it is pointing to the program just
deleted) - I will see Excel install and voila! no more issues with print
preview.
This should not be a permanent solution for this issue. Excel 2007
programmers need to come up with a fix that will permanently fix this issue,
otherwise, I foresee that I will have to delete and reinstall Excel 2007
every time I want to scale a print job to a reduced size.
Need some help here people. Thanks,