Forum Discussion
Copying dates (series)
Hi, Date copying stopped working in this excel as I changed computer. Problem is quite simple, but I cant find answer on tutorials, how to change copying algoritm in dates as it seems to been ch...
I tried that also. No help.
I believe it made no difference if cell format was changed afterwards, like I usually did back then when it worked.
(Tried once more, nope.)
I believe it made no difference if cell format was changed afterwards, like I usually did back then when it worked.
(Tried once more, nope.)
..but I do think it has something to do with cell not changing its format, as it is in the "date" format but even the "Type of date format" doesn't apply to cell, if i change it.
Series is working as I send saved sheet from another excel from another computer.
So got the job done, but still wondering which option is it to lock cell-form like this excel does.
If blanco sheet is opened, the "date-freezing" option is already turned on, and cant get it to work. (unless copying from the working sheet from another excel)