Spreadsheet will not automatically pull updates or connect to my database.  My custom database includes item, description, cost & date entered for products used in my business.  My custom spreadsheet contains a "lookup" formula that refers back to the database when I enter the product ID in the appropriate column.  This has worked flawlessly for the last 20 years on numerous versions of Office and on both Windows and Mac OS.  Since I began using the 2011 version of Office for Mac, my spreadsheet will no longer automatically connect and/or update to the database as it has in the past.  Now, the only way I can get it to "see" the database is to do a manual line by line manual update which is not a viable option due to the amount of time it takes.

Any assistance would be appreciated.