name reverts back to a previous one in Excel 2007

September 28, 2013 at 05:55:31
Specs: Windows 7
At the very top line on the worksheet, it reverts back to August although I have renamed it to September

See More: name reverts back to a previous one in Excel 2007

Report •

#1
September 28, 2013 at 07:02:27
You haven't given us much information to work with.

re: At the very top line on the worksheet...

What do you mean by "the very top line"?

The first row in the body of the sheet? The name of the workbook at the top of the screen? Something else?

re: ...I have renamed it to September

How are you renaming "it"? Of course, we don't yet know what "it" is.

Is the file extension xlsm or xlsb? If it is, there might be macros in the workbook that are involved somehow.

We really need more information before we can offer any advice.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 28, 2013 at 10:47:51
The very top line of the worksheet in blue. When I do a 'save as' I put September, but when I reopen it, it has August on that line. I have been at this job less than a month and did not build this worksheet. However, I have done one for October and it has October on that line. I have to email this to my employer and, although I have September below the company logo, etc. , the fact that there is August at the top line drives her to distraction. The only thing that has saved me so far (I think) is that it did the same thing when she tried to change it one weekend. I'm not at my office right now so I don't remember the extension. I just know it is Excel 2007. Hope this helps.

I use the same worksheet every month and just change the name to be able to use it again. Does that make sense?


Report •

#3
September 28, 2013 at 14:11:42
When I do a 'save as' I put September, but when I reopen it, it has August on that line.


When you do a Save As the current workbook is renamed.

So if your working on a workbook named August
then do a Save As and rename to September,
then the workbook, does not close, but remains open with the new name September.

You need to then either Exit out or Close the current workbook, which has the new name September.

So when you say but when I reopen it, it has August on that line.
it means you are opening the workbook named August, not the workbook
you just renamed as September.

How do you open, close, save, your workbooks?
The exact steps you take.

Where are the workbook names located that you open?
How do you access them?

I would hazard a guess, that the location you access the files from is a Network Drive, somthing like drive P or Q or X,
but the location you are saving them to is a Local Drive, usually C.


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question