samanthanyw
New member
- Joined
- Dec 9, 2019
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Help!
I put in a command into a workbook (Workbook A) where if you click the button, it will automatically open up another workbook (Workbook B) which in turn updates cells in Workbook A. I then save Workbook A and close Workbook A and close Workbook B.
When I open up Workbook A again, I want those cells NOT to refresh unless I click the command button again to open up Workbook B.
The problem is that they immediately return #REF and require me to click the button again.
Help!
I put in a command into a workbook (Workbook A) where if you click the button, it will automatically open up another workbook (Workbook B) which in turn updates cells in Workbook A. I then save Workbook A and close Workbook A and close Workbook B.
When I open up Workbook A again, I want those cells NOT to refresh unless I click the command button again to open up Workbook B.
The problem is that they immediately return #REF and require me to click the button again.
Help!