seannewtoexcel
New Member
- Joined
- Jul 28, 2011
- Messages
- 8
Hi All
Quick question, I have three sheets in an excel file, two of which have sql queries running off them, currently I have to go into the sheet and right click to update the information (date=?) so I manually input the date inoder for the refresh, I want the date pop up box to appear when I open the file as it is the same date used for both sheets, how would I do that?
Thanks for the help.
Sean
Quick question, I have three sheets in an excel file, two of which have sql queries running off them, currently I have to go into the sheet and right click to update the information (date=?) so I manually input the date inoder for the refresh, I want the date pop up box to appear when I open the file as it is the same date used for both sheets, how would I do that?
Thanks for the help.
Sean