Error with linked files....Macro Problem???
 

I have a fairly complex file that has mulitple links to other files. My
problem is some of these links work fine and some of them don't. The ones
that return a #REF error work fine when the file they are linked to is open,
but not if that file is not open. It's weird because there are some links to
other files that don't need to be open to work.

I think this could be a result of macros in other files. When I open one of
these files that my primary file is linked to, a pop up window promps a Macro
security warning even though no Macros exist in the file and any file it
links to does not contain macros either. Could this be causing an issue (the
macro pop up) as far as linked files go???

Another possible issue is the fact that my formula that contains which file
to link to is incorporated in an indirect function. This could be an issue
because the file name to link to is hardcoded on a tables tab and contains
the name of the linked file as: G:\Accounts
Receivable\2006\[filename.xls]range..... but it's not like I am only linked
to the filename, I include the entire source!!

Any suggestions what-so-ever would be greatly appreciated!!!!

Thanks in advance

Error with linked files....Macro Problem???
 

Is it wrong to answer your own question??!!

For anyone that cares, my issue is one a think many people have and that's
just that the file needs to be open. Period. That's just the way excel works.
So the only solution to my problem is to write a Macro that will open the
files and then close them, or to just have them manually opened. If anyone
ever finds a way around this problem I would love to know!!!!

"masterbaker" wrote:

I have a fairly complex file that has mulitple links to other files. My
problem is some of these links work fine and some of them don't. The ones
that return a #REF error work fine when the file they are linked to is open,
but not if that file is not open. It's weird because there are some links to
other files that don't need to be open to work.

I think this could be a result of macros in other files. When I open one of
these files that my primary file is linked to, a pop up window promps a Macro
security warning even though no Macros exist in the file and any file it
links to does not contain macros either. Could this be causing an issue (the
macro pop up) as far as linked files go???

Another possible issue is the fact that my formula that contains which file
to link to is incorporated in an indirect function. This could be an issue
because the file name to link to is hardcoded on a tables tab and contains
the name of the linked file as: G:\Accounts
Receivable\2006\[filename.xls]range..... but it's not like I am only linked
to the filename, I include the entire source!!

Any suggestions what-so-ever would be greatly appreciated!!!!

Thanks in advance