As you describe your issue, I can make out following causes which can make this issue happen.
The network drive which is mapped is disconnected. Have you tried the following steps
Click on Start->Run->type \\System Name\$Drivename\Folder Name\Filename
Click on Ok
Also, try remapping the network drive.
Please follow the steps to reconnect to network drive
<a href=”http://findsarfaraz.blogspot.com”>Free MS Excel help</a>