changing formula
 

I have the formula bellow, which is getting a number from a worksheet within
the permanent file to be added to the monthly worksheet.

=$H$270+'\\nnn.edu\filespace\shared\Shared\_NewSha re\SCHEDULES\[Spring10Perm.xlsx]BSched'!$H282

When changes are made to the permanent file, these changes are not always
carried into the monthly worksheet. Has anyone encounter this problem.
Another recurring problem is deleted information is not permanently deleted.
It sometimes reappears.

we use office 2007 and this is a shared file

thanks for any feedback