I'm stumped!!!

[qmann]

I currently am on a network. I have two users who email excel spreadsheets. User 1 always mails User 2 spreadsheets. Everytime User 2 trys to print preview or print the spreadsheet closes down. The versions they both have of excel are the same.

I've thought of everything and can't think why this would be doing this. When User 1 mails a spreadsheet to anyone else it is fine. When User 2 receives excel sheets from anyone else he has no problem it is just that one particular user.

I am stumped. Any suggestions???

 

[01Patrik]

Hey,

No suggestions on how to get it fixed, but you can always avoid the problem by marking all sheets (by holding down shift), right-click and move the sheets to a new workbook. This sets the author as the current user, which should avoid the problem with printing and previewing as long as you have correctly identified the source of the problem.

Good luck finding the real solution

 

[MakeItSo]

Sounds like a printer driver issue to me.
Tell User 2 to remove any invalid printer drivers (e.g. from network printers no longer present) and to re-install his printer.

Hope this helps,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://andygalambos.de

 

[jonsi]

I don't understand why Users on the same Network are emailing files to each other.

Surely it makes sense to place the files in a Network Share where they can both access them?

 

[tviman]

I agree with Jonsi! A "Network Share" or "Public" directory is the norm and is available to all users. Simple "drag-n-drop" the file to this directory and it's available to others. Easy!

There's always a better way. The fun is trying to find it!

 

[MakeItSo]

When User 2 receives excel sheets from anyone else he has no problem

I overread this part. Forget my post, can't be the printer then...
Besides that, the guys are right. there might be no need for mailing the sheets at all.
Still the problem itself remains:
Has User 2 tried to save the sheet to a local folder and open it from there?
Might be some setting in Outlook or a missing SP/Patch on User 1's side causing some sort of corruption in the file.

Will sending the file zipped cause the same problems?

Cheers,
Andy

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://andygalambos.de

 

[qmann]

Okay I'll try on the network.

Email is just preference by the users. I'll try to send over the network

Thanks for the tips.

Q