Remove previous file reference

M

mkerstei

Hi,
I currently am working on editing a template on of my coworkers ha
edited and needed some changes to. Unfortunately, the spreadsheet i
automatically prompting for a file that it no longer uses. There is n
reference to it within the file itself, meaning I believe it it lookin
for previous code or something. The current file has no use for thi
referenced file though, so I need to get rid of it so it stop
prompting the user to find the useless file. Any ideas
 
M

macropod

Hi mkerstei,

Does the old file still show up if you use Edit|Links? If so, you still have
a reference to it. The reference could be in a formula (most likely), a
defined name or a macro.

You cab use Edit|Find to search each worksheet for the filename in a
formula, Insert|Name to look for it in a defined name or Alt-F8 to see if
there's a macro with a reference to it.

Cheers
 
M

mkerstei

You got it...it was a named range. i can't believe I missed that.
Thanks for your help
 
M

mkerstei

You got it...it was a named range. i can't believe I missed that.
Thanks for your help
 
Top