98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data validation
Data validation
Resolved · Low Priority · Version 2010
Fri 3 Jun 2011, 16:40Delegate Natalie said...
Natalie has attended:
Excel Advanced course
Data validation
Can you assign a macro to refresh the data?
Mon 6 Jun 2011, 11:37Trainer Mark said...
RE: data validation
Hello Natalie,
Thank you for your question regarding macros and refresh.
The key for refresh is F9, so you could record a macro and press the F9 key. Playing back the macro will refresh.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Mon 13 Jun 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Percentage formatCtrl+Shift+% applies the Percentage format, with no decimal places. |
