Changing source file 'cannot be found' error

[seanrmckenna]

Hi all,
I'm trying to update the links to a new file and Excel 2007 is saying "xxxxx file cannot be found. Please check your spelling or try a different path".
The file path is definitely correct. No folders have had their names changed etc.
The file was used a new user who has her network drive mapped slightly different to everyone else, but now when any of us try to update the links it doesn't work. That is not necessarily the cause but it's the only thing I can think of.
I've tried using 'Open source'.
I've tried opening the source file first and then the file I am trying to update.
None of those are working, either on the computer with a different mapping or on any of those with a 'normal' mapping.

Any way of getting the main file to recognise its source file again?

Thanks very much,
Sean

 

[Gingertrees]

Your suspicions are correct - if everyone at the office has their network drive mapped to Y:, and she has it mapped to X:. yes, it has the potential to screw up the links.

Best thing you can do is get her drives mapped like everyone else and possibly re-do the links in the file with the main network address instead of the mapped drives. I've dealt with this before and it is quite the female dog to deal with. Good luck.