I have users who have large Excel spreadsheets from MS Office 2000. They save them to their private drive on the server. I upgrade their PCs and they receive a new one with a new MS Office 2000 program installed. They pull in their Excel spreadsheet and find that their spreadsheet is too large and they have to resize it manually to get it to print on one page. Why is this? I would think that any size settings would be saved with the spreadsheet. Can anyone help me? It is getting to the point where my users are worried when I upgrade their PCs because they know it will cause them extra work.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Why do Excel spreadsheets resize??
- Thread starter shunter40
- Start date
JVFriederick
IS-IT--Management
Just a guess....
The only time I have had this problem is when changing printers, when the physical printing margins must be different to handle the paper feed. If one of your users is having this type of problem, check the margins. If they are THAT "close to the edge", well . . . . .
Sounds like you have a tough bunch of customers.
The only time I have had this problem is when changing printers, when the physical printing margins must be different to handle the paper feed. If one of your users is having this type of problem, check the margins. If they are THAT "close to the edge", well . . . . .
Sounds like you have a tough bunch of customers.
- Thread starter
- #3
Thanks for the response...and I have also had the problem when changing printers also, BUT, in these cases (more than 1) the printer stayed the same, it was only the PC that changed with the same o/s, WIN98 second edition, and the same version of Office, Office Professional 2000.
The only thing that I think may be the problem, is in Page Setup, when the user chooses "Adjust to xx% normal size". But if the user chooses, let's say, 80% of normal size, those settings are still the same when they open the saved spreadsheet. But they still have to manually decrease columns and font sizes to get the page to fit.
The only thing that I think may be the problem, is in Page Setup, when the user chooses "Adjust to xx% normal size". But if the user chooses, let's say, 80% of normal size, those settings are still the same when they open the saved spreadsheet. But they still have to manually decrease columns and font sizes to get the page to fit.
NO SHUNTER.
Please don't change the font and stuff. This is definitely NOT the way to make a spreadsheet fit on a page. They are doing it right, but let's suppose the new printer driver works differently.
They should be using print to 1 (one) by and leave the number of pages blank--clear any number out of there for most files. Some files they will want to have a 1 in there also.
I have heard of this before and hate to sound so lame as to say that I have not heard of any fix or cause.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word at
Please don't change the font and stuff. This is definitely NOT the way to make a spreadsheet fit on a page. They are doing it right, but let's suppose the new printer driver works differently.
They should be using print to 1 (one) by and leave the number of pages blank--clear any number out of there for most files. Some files they will want to have a 1 in there also.
I have heard of this before and hate to sound so lame as to say that I have not heard of any fix or cause.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word at
- Status