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.
撰写回答