How sure are you that it does not contain macros?
Can you make a copy of the file and then enable macros in that copied file? What then happens, if anything? Does the file change in any identifiable way---file size, for instance--anything that might indicate that a macro had actually run?
I don't know if that message can be turned off or if that message is necessarily incorrect.
I use macros in just one of my many Excel files and don't think I've ever seen that message except perhaps on a new installation.
Is this while logged in as the same user as for all other Excel files?
Is the file known to be virus and malware free?
I scanned the file with McAfee and it said there were no viruses or other security issues, so that's good. Thank you for the suggestion.
I am logged on as the same user for all of the Excel files, as far as I know. This is the only file where I encounter this issue.
It could be that when I was using Windows XP in 2012 or earlier, I might have been using a different user name for Windows but no specific user names were assigned to the Excel workbook. Could that be an issue if I used a copy of a workbook created in Windows XP to create a new workbook in Windows 7?
When I made a copy of the file and opened it, as you suggested, I did get the same message where I had the option to choose either DISABLE MACROS or ENABLE MACROS. When I chose ENABLE, nothing perceptible changed.
This Excel workbook has a separate spreadsheet for each month plus a few other pages, so it's a bit difficult to detect any subtle changes but I didn't see anything obvious when I made the copy.
I should note that there is another issue with this workbook, but I created separate threads for the two issues in an attempt to keep things simple (
http://www.sevenforums.com/microsof...rnings-links-other-workbooks.html#post3174511). The other issue is that regardless of whether I choose DISABLE or ENABLE for the macros, another message follows that tells me this workbook is linked to another workbook and it gives me the option to update this workbook with changes to the linked workbook - or not. There is no apparent difference with any of the data in this workbook regardless of which option I choose.
It was the same with the copy, followed by another message:
If you want to permanently change the source of a link, click Links on the Edit menu, click the link in the list, and then click Change Source.
I did that, but the only option it gave was to change the link from the workbook it had listed to different Excel file. It wasn't possible to eliminate the link. The only options were to link it to a different file or leave it linked to the one listed.
The workbook it has listed is the file I copied from last year to create this year's file. Could I have inadvertently created a link to last year's file when copying it to create this year's?
If so, is there a way to change that? If not for this year's workbook, perhaps when I copy this one to create next year's?
Is it possible that this "link" is the macro?
