Queen Elizabeth will usually spend time in early August, but you should check with tourist authorities if Holyrood is a must-see for you.
In the beginning of August you can usually find Queen Elizabeth there.