I am having a problem with a couple of specific worksheets that I have created with specific formats. I created the worksheets and saved them on the lan for sharing between several users. When the file is opened up on my PC the formats are fine and the file prints as I set it up; however, when the same file is opened up from a different PC, while the settings (i.e. margins, footers, etc.) are the same, the page breaks change, columns get cut off, and the file prints differently. I don't know if this has something to do with the way the other users have their default excel settings or their default PC settings, but I was hoping that someone may have some ideas about what may be causing this. Thanks to anyone for your help.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Worksheet formats - help with saving on a lan
- Thread starter rfowlston
- Start date
Agree with Hasit.
If you have a selected print area, and you're NOT telling it to "fit to X by X pages", then their printer may be printing it differently. If you choose the "fit to", it should work for everyone regardless of printer. Brainbench MVP for Microsoft Word
techsupportgirl@home.com
If you have a selected print area, and you're NOT telling it to "fit to X by X pages", then their printer may be printing it differently. If you choose the "fit to", it should work for everyone regardless of printer. Brainbench MVP for Microsoft Word
techsupportgirl@home.com
- Thread starter
- #4
The printer settings idea sounds logical, I will have to check on them, expecially since this problem is occuring not only in Excel, but in some cases, Word also. (However, I tried the fix x by x pages option that Dreamboat pointed out and it still didn't work.)
Word and Excel:
Best default settings for page margins is .75" footer and 1.25" bottom margin--US measurements. A little HP deskjet can't print that close to the bottom of the paper, so when making "shared" documents, you need to allow for any printer, usually. Also compare print job from each printer. Do the lines of text line up exactly? Don't be surprised if they don't. Brainbench MVP for Microsoft Word
techsupportgirl@home.com
Best default settings for page margins is .75" footer and 1.25" bottom margin--US measurements. A little HP deskjet can't print that close to the bottom of the paper, so when making "shared" documents, you need to allow for any printer, usually. Also compare print job from each printer. Do the lines of text line up exactly? Don't be surprised if they don't. Brainbench MVP for Microsoft Word
techsupportgirl@home.com
- Status
Similar threads
- Locked
- Question