I have a problem with a workbook that is not working in a Citrix environment. The file works correctly on my Desktop environment. Note that I'm running Excel 2010 in both environments.

I've done the following test to try and determine the cause of the problem.

I open a copy of the file on my Desktop and another on the Citrix Desktop. In the VBA Editor I open the Immediate Window and enter the following code.

?Thisworkbook.Worksheets("Setup").Range("F9").Text

On my desktop, I get the text of the cell, but on the Citrix Desktop, I get Runtime Error 32809.

I've seen references that suggest re-building the workbook, but given 20 sheets, several hundred defined names(both at workbook and worksheet level) 2,500 lines of code and a bunch of buttons and other controls, this would take days and would be very likely to introduce bugs.

Is there a solution to this issue that doesn't require a complete rebuild of the file?

Thanks

Gordon