MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel warnings & save as date


Posted by Craig on July 10, 2000 7:09 AM

I have cells linked to another WB and excel always asks if I want to update the WB it is reading from. is there a way to have the WB update automatically?

Also I am trying to save my wb as a date, but can't get excel to place a date without '/' in a cell and you can not have any slashes in a file name. any ideas?


Posted by Ada on July 16, 0100 5:40 AM

Re: save as date

Craig
I don't know if this will work but try inputting the date into the cell in a format that Excel does not recognize as a date (for example :- 31.7.00 )
Alternatively, try formatting the cell as text before you enter the date.
Also, you might like to look at "SaveAsMMMYYYY.xls¡¨ at :-
(broken link)
Ada

Posted by Greg MItchell on July 10, 0100 7:36 AM

If you look at the formatting options, under Number, choose Date and you can choose a bunch of different formats that don't have /'s in them. If you don't like any of them, you can always use the custom cell format.

Posted by craig on July 10, 0100 9:00 AM

:Greg,
changing the format changes what is displayed in the cell, but the value shown in the menu bar still contains /'s and this is what is read when I try to link the cell to a save as... command.