Excel Page Range Printing Problems

Occassionally we have clients that have been working in excel constantly and
when they go to print preview the spreadsheet page setup is set to print 1 x
1, which it should, but it reduces the spreadsheet to 54% (very very small).
If you exit excel and go back in it doesn't recreate the problem. Sometimes
the clients have to reboot and when they enter back into a spreadsheet
everything is back the way it is suppose to view. Everyone is accessing
different excel workbook. We have office 2000 fully patched along with all
security patches.

This is starting to happen on more than one machine. Any advice is wonderful.

Typically, I would think print driver, but am not sure why rebooting or
closing and loading XL would fix the problem....

A macro or something may be activating a cell away from the main body.
you can check what area is selected for print area by <View>< Page break
preview>
Or another way to do this is by checking <edit><goto><special>select last cell

Do one of these after people have been working on the files and try to find
out when the print area has changed.

"SkyEyes" wrote:

> Occassionally we have clients that have been working in excel constantly and
> when they go to print preview the spreadsheet page setup is set to print 1 x
> 1, which it should, but it reduces the spreadsheet to 54% (very very small).
> If you exit excel and go back in it doesn't recreate the problem. Sometimes
> the clients have to reboot and when they enter back into a spreadsheet
> everything is back the way it is suppose to view. Everyone is accessing
> different excel workbook. We have office 2000 fully patched along with all
> security patches.
>
> This is starting to happen on more than one machine. Any advice is wonderful.