Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
Excel 2003 - Common file prints differently for different users
LaOs
Registered User regular
Registered User regular
Apologies--I originally posted this on the MrExcel.com forums but there have been no replies, so I wanted to see what the userbase here knew. Sorry for the cross-posting (but thanks for your help!)
Hey, this is a rather strange situation...
At work we have this Excel program that prints out barcode labels, automatically updating the labels for new sheets as needed. It's stored on a shared drive and has been formatted to print correctly out of one printer attached to one workstation.
When I log into that workstation as my profile, the labels align properly and print perfectly. However, when my coworker logs into the same workstation and accesses the same file (both of us access it from the community-shared drive), the labels do not align nor print properly.
I cannot imagine why the same file is behaving differently for her than it does for me, and the only thing I can think of as different is the difference in her logging in as her profile or me logging in as my profile.
Could this really be the difference? And if it is, why is it, since it doesn't make any sense. Hopefully there's some other problem I'm missing, and I'm more than happy to answer and clarification requests. I just don't get why the same file is acting up like this for her but not for me.
Thanks for your time and help!
Hey, this is a rather strange situation...
At work we have this Excel program that prints out barcode labels, automatically updating the labels for new sheets as needed. It's stored on a shared drive and has been formatted to print correctly out of one printer attached to one workstation.
When I log into that workstation as my profile, the labels align properly and print perfectly. However, when my coworker logs into the same workstation and accesses the same file (both of us access it from the community-shared drive), the labels do not align nor print properly.
I cannot imagine why the same file is behaving differently for her than it does for me, and the only thing I can think of as different is the difference in her logging in as her profile or me logging in as my profile.
Could this really be the difference? And if it is, why is it, since it doesn't make any sense. Hopefully there's some other problem I'm missing, and I'm more than happy to answer and clarification requests. I just don't get why the same file is acting up like this for her but not for me.
Thanks for your time and help!
LaOs on
Posts
I'm not sure. What's the easy way to check that for sure?
I had come across that possibility, and where I found that, I also found that supposedly locking the workbook was supposed to prevent a user's defaults from overriding the settings within the sheet... but maybe that wouldn't work?
I'll look into it, though. Thanks.
Well, it is, but it's the simpler one of the many versions we have of it... it's just the barcode labels, without the well locations or anything. (The incrementation and everything else is working just fine for both of us.)
It's just such a strange problem to be having. I could understand if my coworker was trying to print on a different printer, because I've experienced troubles doing that, but I've gone and painstakingly aligned the columns and rows to print correctly on this one printer, and even there it's giving her grief. So odd.
So far as program-specific issues, I don't think there are any, aside from this strange printing problem, and I don't know if that's really program-specific in the sense you mean.
They don't, they're stored in the file.
Is her screen resolution the same as yours? That might do it.
There should be an option in the image preferences or whatever for each barcode to have them move/resize with the cell they're attached to. You probably want to get that checked, so that they're bound to whichever cell you set them on top of.
CUZ THERE'S SOMETHING IN THE MIDDLE AND IT'S GIVING ME A RASH
I thought the preferences were set in the file, yeah, but anyway...
I'm not sure what you mean about images, Pheezer, so I may be reading you wrong, but there are no images involved at all in the file/with the barcodes--it's all text.
Would her screen resolution matter outside of your concern with images?
The reason I say it's definitely a file setting is that I have a dozen things I print, each of which has its own defaults, some of which are different from one worksheet tab to the next, which all persist. There's no way it's creating a new entry in my user profile every single time I create a spreadsheet.
I hope. That'd be absurd if it were.
It sounds like you might have a case of Excel just bein' weird? I don't know, have you tried setting the file to print correctly on her profile, and then saving it? Also, is this a single file on a shared drive, or is it a file that's been e-mailed to her?
I no longer suspect screen resolution if there are no images involved. But I guess anything's possible with Office.
CUZ THERE'S SOMETHING IN THE MIDDLE AND IT'S GIVING ME A RASH
Oh. Yeah, it's not images at all. Those vertical lines in the barcode are actually one of many types of fonts. Its all text.
It's clearly Excel being weird, but that's lame and there's got to be some reason, no? haha.
It's one file stored on a communcal drive that we can both access. We open the exact same version of the file each time.
I could piss around with the margins and make it work for her, I guess, but that's going to be a pain in the ass and if it doesn't work, I need to re-fix it so it at least works for me... and having two files will work, I guess, but makes the process more confusing for people who have enough trouble just using the program as-is, and loses the consistency from one printing batch to the other, which is important to maintain.
Hopefully there's another way than simply making her a new version of the file. Thanks though.
You record a macro. Open the file in exclusive mode on her machine, and record a macro of you re-sizing everything to be correct. Save the file.
Now whenever she needs to print, she runs that macro and lookit that it's perfect and prints just right.
CUZ THERE'S SOMETHING IN THE MIDDLE AND IT'S GIVING ME A RASH
But, if it comes down to it, that'll work I guess. Thanks.
What's exclusive mode?
Also, why wouldn't you be able to have it auto-save?
CUZ THERE'S SOMETHING IN THE MIDDLE AND IT'S GIVING ME A RASH
Oh, cool.
If I save the changes of making it fit when she prints, when I open it to print, it's going to be off again.
CUZ THERE'S SOMETHING IN THE MIDDLE AND IT'S GIVING ME A RASH
Either way, it is a viable workaround (changing the file), but I was really hoping there might be some idea as to why it is behaving this way and how we might troublshoot that.
CUZ THERE'S SOMETHING IN THE MIDDLE AND IT'S GIVING ME A RASH
Ha. Okay... dinger. Thanks for your help though.