Rename sheet in workbooks(2) changes workbooks(1) saved status

The setup:

Workbooks(1) is open in the background
A cell in a worksheet in Workbooks(1) contains an Offset formula - e.g. =OFFSET($A$1,0,2,1,1)
There are no external references in Workbooks(1)
Workbooks(2) is open in the foreground

Open the VBE and in an Immediate window....

workbooks(1).Saved=True
?workbooks(1).Saved
>> True
activesheet.name="asdfg"
?workbooks(1).Saved
>> False

So nothing has been done to Workbooks(1) and there are no references in Workbooks(1) to Workbooks(2) but the saved status of Workbooks(1) changes when a worksheet in Workbooks(2) is renamed. It's the same in Excel 2010 and 2013. This looks like a bug to me but maybe I'm missing something?

Regards, AB

Originally Posted by natefarm

I doesn't seem to work that way for me. Try it with two different workbooks and see if the results are the same.

I have tried with different workbooks and on two different PCs - W7 laptop with Excel 2013 and W8.1 desktop with Excel 2010.

Regards, AB

Here's the test code I use in the primary workbook. The STOP statement lets me step through to see what is going on line by line.

Please Login or Register  to view this content.

The secondary workbook should be called S.xlsx and placed in the same folder as the primary P.xlsm workbook. In my test case the single worksheet looks like this...

XLbug-01.png

Regards, AB