gidget Wrote:
I received an excel worksheet. It's named "fileA 24Aug2005.xls". When i
open it up on my mac in excel, the date truncates to something like
"fileA #17D114.xls. This wouldn't be a problem, except that when i
print their file from my computer, the new name, prints at the bottom
of the worksheet which won't fly because the new name printed wouldn't
match their database.

2 questions.

1) where is this file name stored and where is the command that tells
it to print at the bottom, because i don't see it on my screen, only
the printed copy.

2) how can i open a file without changing the system changing the
name?

very grateful for any insight.

Mary

Hi Mary

The file name at the bottom is probably in Footers, click View Header
and Footer, under footer click the down arrow and select none

Don't know how it changes the name sorry


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=480604

Paul - thanks for the tip, that worked.

now i just need to figure out why when i open the original file, the
name changes on me. i have 54 files and they all end with a date like
24Aug05. that's the part that changes on me. it must have something to
do with an auto naming from the original user?

i was poking around in the footer section and went to the section where
you could insert the &[File]. that's the part that's going to goof me up
unless i can somehow prevent it from renaming the file. thanks your help
and thanks for any insight.


--
gidget
------------------------------------------------------------------------
gidget's Profile: http://www.excelforum.com/member.php...o&userid=28460
View this thread: http://www.excelforum.com/showthread...hreadid=480604