I have tried to produce a Visual Report from the common resource pool whilst having only one small project shared with it and I unfortunately get the same response as previously reported.
I have checked the service pack status and already have XP SP3 and Project 2010 SP1 so cant see theres a gap there.
I have requested our IT department update my laptops MSExcel from 2007 to 2010 tomorrow.
At least I now know that it can be done which is encouraging.
Many thanks for the support & I’ll report back once tested with Excel 2010.