File in C drive is always trying to access Drive A
 

Hi,

I have a file in my C drive where I keep all my Excel goodies.

When I open that file, every time I recalculate the sheet, it always tries
to access a file from my Drive A.
If I have the calculation on automatic, it tries to access Drive A every
time.

I do not have any links with a reference to a Drive A.

I tried the findlink.xla add-inn with all the links, but with no success in
finding the problem

I even deleted ALL the links, yet the file still tries to find the DriveA

Any ideas, why it does this, and does anyone have a solution?

Thanks

André

Do you have named ranges that might refer to a file on your A drive?
Or perhaps a macro assigned to a button, and the macro resided in a
file on the A drive?

Hello Dave,

I had checked all the Range names, and no link to Drive A:

I do have a link to a name called "Cumul", but there is no reference to a
file name. The source file has only: Cumul.
Even with the FindLink.xla add-in, I can't seem to delete that link.

I can only imagine that is the source of my problem.

I have many macro buttons, and will verify each one of them while going to
work on the train this morning...

will come back later tonight...


"Dave O" wrote in message
ups.com...
Do you have named ranges that might refer to a file on your A drive?
Or perhaps a macro assigned to a button, and the macro resided in a
file on the A drive?

Hi again Dave,

I was able to isolate the "corrupt" sheet by deleting each sheet one after
the other, and verifing after each deletion if the corresponding link was
eliminated.

Problem is now solved, eventhough I could not identify its origin.

Thanks for putting me in the right direction.

rgds

André





"Dave O" wrote in message
ups.com...
Do you have named ranges that might refer to a file on your A drive?
Or perhaps a macro assigned to a button, and the macro resided in a
file on the A drive?