vbacoder
Active Member
- Joined
- Jul 7, 2007
- Messages
- 354
Hi everyone,
I have some links to cells in closed worksheets that do not seem to update to the value in the source cell unless the source worksheet is open.
When I open my workbook, I get a message telling me that some of the links could not be updated, and I have the option to edit links or continue. Upon editing links, when I enter refresh, nothing changes. The values are still not pulled into the workbook from the closed sheets.
The only way to get values in seems to be to open the source worksheets, which defeats the object of the exercise.
The source worksheets are located on a networked drive, so the network may be part of the problem. I have permissions to read and modify the files.
Please could anyone help me fgure out a possible cause for the problem I'm having?
Thank you.
vcoder
I have some links to cells in closed worksheets that do not seem to update to the value in the source cell unless the source worksheet is open.
When I open my workbook, I get a message telling me that some of the links could not be updated, and I have the option to edit links or continue. Upon editing links, when I enter refresh, nothing changes. The values are still not pulled into the workbook from the closed sheets.
The only way to get values in seems to be to open the source worksheets, which defeats the object of the exercise.
The source worksheets are located on a networked drive, so the network may be part of the problem. I have permissions to read and modify the files.
Please could anyone help me fgure out a possible cause for the problem I'm having?
Thank you.
vcoder