Excel: Linked Cell Report



It's been a while, but I thought I'd post this interesting thing I did over lunch today.













Have you ever opened an Excel file and had a popup ask you to "refresh linked cell" contents? As time goes by and Excel files get larger and larger, sometimes it'd be nice to know what cells in the file are actually linked. I couldn't find a quick menu item to do this, so I created one!

here is the source (linkedcells.bas)


Give it a try and let me know how it goes.

Until next time...Rich

Followup:

A friend found these two links for me:

http://support.microsoft.com/?scid=kb;en-us;192895

http://support.microsoft.com/kb/q188449/

Comments

Popular Posts