Hi,
I have a simple database file that contains an account master sheet, an account holdings master sheet, and an account view sheet for pulling in data from the other two and displaying it tidily. Macros are used to pull in holdings data when an account name is selected from the dropdown list on the account view sheet. In Excel 2010 running on Windows 7 Ultimate Service Pack 1, these holdings populate the sheet correctly when an account is selected from the dropdown. In Excel 2011 running on Mac OS X 10.7.2, however, selecting names from the dropdown causes only the account notes (blue fields in the upper half of the sheet) to populate correctly. The holdings (yellow lines across lower portion of the sheet) do not populate correctly on a Mac.
Does anyone know why the Macros run and the account view sheet displays correctly on Windows, but not on a Mac? I am totally perplexed by this, as the code is the same. Are there any settings that need to be changed on the Mac? Is it some sort of display issue? I would love to have the file display correctly on a Mac with default Excel settings.
I've attached the file in the hope that someone with access to both operating systems can test it and provide some insight. Thanks so much in advance for any help or advice.
Bookmarks