Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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é |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot access a file -- HELP | Excel Discussion (Misc queries) | |||
How can I secure a file from unauthorized access? | Excel Discussion (Misc queries) | |||
Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
file access & options settings | Excel Discussion (Misc queries) | |||
Network access to file - read only property | Excel Discussion (Misc queries) |