My desktop was recently upgraded to Windows 7 and Excel 2010. When I attempt to run VBA where I am copying information from one spreadsheet to another, I consistently receive Error 1004 PastSpecial Method of Range Class Failed.

However, the same exact file runs perfectly on my laptop, which also runs on Windows 7 / Office 2010. It's obviously something goofy with the install on my desktop.

I checked the VBA references on both machines and they are the same.

Any ideas of where I could look to see what is different between the two machines? Our IS folks have no idea.

One variance between the two computers is that the desktop has Hyperion Essbase installed and the laptop does not. That does not work, either.

Thanks for any suggestions you may have.