Excel error message when closing Personal file.

[Sue Kelley]

When I close my Personal macro file, I get the error
message, "This workbook is currently reference by another
workbook and cannot be closed". When I hit OK or close
the dialog box, Excel will close. I has no impact on the
file itself but is annoying. I'd like to solve correct
this but nothing I've seen addresses this issue.

 

[Kent]

Is your personal macro file local or on a server? How
about the workbook? If workbook is shared on a server,
how big is the file, what virus checker exists on your
machine, the server. First glance it sounds like a delay
save type of issue.

Excel Support Technician
www.canhelpyou.com

 

[Sue Kelley]

My Personal file is on my hard drive. We currently use
McAfee. It wasn't an issue initially but started to
appear a few months ago. Can't figure out what I did that
resulted in this error message.