Problem with XL´97 / 2000

Sven Eichler · Apr 24th, 2002, 02:25 AM

Hi out there!

I have this problem: I am a System administrator in a 35-people company. One of our Users got an XL-Sheet from one of our customers, and it was working fine. Then I chaned her PC to a newer one, including Win2K and Office 2K. So now, she tries using the thing, and if she tries to print out a part of it, XL says something like (I don´t know the exact phrase in english): "Printborders don´t fit on page".
If you go to print preview, the pages appear really, really small, the borders are so screwed up, that you have to manually pull themapart in order to see anything on the paper.
Question: Does this have anything to do with the change from Office97 to Office2000? Because other Users with Office97do not haqve Problems with it. What can I do? Help!!!

gareth · Apr 24th, 2002, 02:35 AM

That should not be the core of the problem my friend.That should not nececerally be an excel fault,it could be from changing over to the newer version.Anybody can correct me if I am Wrong.Before you shifted from old to new......did you save you files ?

Try opening it as a excel 97 file and then it to 2000.See if it works then give me a shout again via e-mail page117 on board

Sven Eichler · Apr 24th, 2002, 07:40 AM

@ Gareth: Hi, gareth, and thanks for your quick reply! As I am a new Member on this site, here is a short question: Why would I reply to you via e-mail if this is an official board-topic??? Do yoy always do it like that in here? I don´t mind, it´s just that I am not used to it from any other IT-board...
If I am to reply via e-mail, what do you mean by "e-mail-page 117"???

HELP

))

Chris Davison · Apr 24th, 2002, 02:31 PM

Sven,

reply to the board, this way we can all share the knowledge

anyhow...

Sven,

have you checked the printhead alignments within windows ? :

start
settings
printers
~right click her printer~
properties
utilities
print head alignements

this may not help, but at least it could eliminate a potential problem

Jack in the UK · Apr 24th, 2002, 03:45 PM

Ok i haver waighted on this onem i go for zoom settings and printer drivers

Reason
|||||||||||||||

Excel can not and never will print, this is a linked command to istruct windows spool manager and print manager to print via trigger event.

so i guess Drivers W2K Win is quite good but can through out prev settings if upgraded.

suggest fix:

remove uninstall drivers and relaod NEWEST drivers chack web for manufactures drivers might be newer.

Sven Eichler · Apr 25th, 2002, 12:55 AM

`morning!

OK, here is what I´ve got: Zoom-settings are at 85%, that way it has to work out, I checked that yesterday with an office97. Printer driver is not the reason, for I´ve tried that out myself before posting with a whole whack of different drivers. The weared thing is, that I tried it on another Win / Office2000 machine, and it worked!
So question: Where can I adjust any attributes that cause the document to change in the prescribed way???

Sven Eichler · Apr 25th, 2002, 12:55 AM

`morning!

OK, here is what I´ve got: Zoom-settings are at 85%, that way it has to work out, I checked that yesterday with an office97. Printer driver is not the reason, for I´ve tried that out myself before posting with a whole whack of different drivers. The weared thing is, that I tried it on another Win / Office2000 machine, and it worked!
So question: Where can I adjust any attributes that cause the document to change in the prescribed way???

Jack in the UK · Apr 26th, 2002, 01:07 PM

try open file in XP or 2000 excel PC and save as new name..

nowe try on doggy PC , not really doggy just a discripton of other PC.

This will rely on Excels advances in backwards compability and hope that any curut sections or now formed gaps the the bianry file structure is recovered / repaired and will allow 97 to open

If so re save as something quick so workable WkBk about in case all goes #^#^@#^&#^&

Sven Eichler · Apr 30th, 2002, 04:05 AM

Hi out there!

I have tried everything, but it just seems that maybe this file does have a problem, the weird thing is just that this occured directly with the upgrade to Office2000 and I am not going to believe in a coincidence... (if that is spelled wrong forgive me, for I am from Germany... =

)
Does anyone else have any idea? The user is just about to take my head off... Understandeable but also painful...

robfritts · Apr 30th, 2002, 08:20 AM

I'm not too familiar with the inner workings of excel or their migration strategies, so someone let me know if this is inacurate.

I would suggest that maybe the file was corrupted somehow previously but that the new excel binary was more sensitive to it and brought it to light.

Apr 24th, 2002, 02:35 AM	#2
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	That should not be the core of the problem my friend.That should not nececerally be an excel fault,it could be from changing over to the newer version.Anybody can correct me if I am Wrong.Before you shifted from old to new......did you save you files ? Try opening it as a excel 97 file and then it to 2000.See if it works then give me a shout again via e-mail page117 on board __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Apr 24th, 2002, 02:31 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Sven, reply to the board, this way we can all share the knowledge anyhow... Sven, have you checked the printhead alignments within windows ? : start settings printers ~right click her printer~ properties utilities print head alignements this may not help, but at least it could eliminate a potential problem __________________ :: Pharma Z - Family drugstore ::

Apr 24th, 2002, 03:45 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Ok i haver waighted on this onem i go for zoom settings and printer drivers Reason \|\|\|\|\|\|\|\|\|\|\|\|\|\|\| Excel can not and never will print, this is a linked command to istruct windows spool manager and print manager to print via trigger event. so i guess Drivers W2K Win is quite good but can through out prev settings if upgraded. suggest fix: remove uninstall drivers and relaod NEWEST drivers chack web for manufactures drivers might be newer. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 26th, 2002, 01:07 PM	#8
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	try open file in XP or 2000 excel PC and save as new name.. nowe try on doggy PC , not really doggy just a discripton of other PC. This will rely on Excels advances in backwards compability and hope that any curut sections or now formed gaps the the bianry file structure is recovered / repaired and will allow 97 to open If so re save as something quick so workable WkBk about in case all goes #^#^@#^&#^& __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 02:25 AM	#1
Sven Eichler New Member Join Date: Apr 2002 Location: Lahr / Germany Posts: 7	Hi out there! I have this problem: I am a System administrator in a 35-people company. One of our Users got an XL-Sheet from one of our customers, and it was working fine. Then I chaned her PC to a newer one, including Win2K and Office 2K. So now, she tries using the thing, and if she tries to print out a part of it, XL says something like (I don´t know the exact phrase in english): "Printborders don´t fit on page". If you go to print preview, the pages appear really, really small, the borders are so screwed up, that you have to manually pull themapart in order to see anything on the paper. Question: Does this have anything to do with the change from Office97 to Office2000? Because other Users with Office97do not haqve Problems with it. What can I do? Help!!!

Apr 24th, 2002, 07:40 AM	#3
Sven Eichler New Member Join Date: Apr 2002 Location: Lahr / Germany Posts: 7	@ Gareth: Hi, gareth, and thanks for your quick reply! As I am a new Member on this site, here is a short question: Why would I reply to you via e-mail if this is an official board-topic??? Do yoy always do it like that in here? I don´t mind, it´s just that I am not used to it from any other IT-board... If I am to reply via e-mail, what do you mean by "e-mail-page 117"??? HELP ))

Apr 25th, 2002, 12:55 AM	#6
Sven Eichler New Member Join Date: Apr 2002 Location: Lahr / Germany Posts: 7	`morning! OK, here is what I´ve got: Zoom-settings are at 85%, that way it has to work out, I checked that yesterday with an office97. Printer driver is not the reason, for I´ve tried that out myself before posting with a whole whack of different drivers. The weared thing is, that I tried it on another Win / Office2000 machine, and it worked! So question: Where can I adjust any attributes that cause the document to change in the prescribed way???

Apr 30th, 2002, 04:05 AM	#9
Sven Eichler New Member Join Date: Apr 2002 Location: Lahr / Germany Posts: 7	Hi out there! I have tried everything, but it just seems that maybe this file does have a problem, the weird thing is just that this occured directly with the upgrade to Office2000 and I am not going to believe in a coincidence... (if that is spelled wrong forgive me, for I am from Germany... = ) Does anyone else have any idea? The user is just about to take my head off... Understandeable but also painful...

Apr 30th, 2002, 08:20 AM	#10
robfritts New Member Join Date: Apr 2002 Location: KC, MO Posts: 18	I'm not too familiar with the inner workings of excel or their migration strategies, so someone let me know if this is inacurate. I would suggest that maybe the file was corrupted somehow previously but that the new excel binary was more sensitive to it and brought it to light.