Hello all,

I am pretty new to writing VBA, and I have a Macro that is triggered by a data validation drop down that was written on my PC in Excel 2010. Everything works perfectly when I run it on my computer, but as soon as I try to run it on a Mac running Excel 2011, Excel crashes and closes with no error message. I have tried using Form Control Drop Downs, Form Control Radio buttons and and Data Validation was my last hope. The whole purpose of the code I am trying to execute is to convert about 20 pivot tables from USD to Euros and they are all fed by a table that contains about 60,000 rows of data. Everything that I have researched says that Data Validation and Form Controls should work in Excel 2011, and the last thing I found basically says that Mac can't handle the large amount of data. I was hoping that someone may be able to help me with an option or work around that might allow me to keep the conversion functionality when operating on a Mac.

In case it is helpful, the data set contains the values for USD and Euro, and the macro is simply removing the USD Fields and replacing them with the Euro Fields and then formatting the pivot tables so that is looks identical, just with different currency values.

Any thoughts would be greatly appreciated!