Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table.

However, Excel 2008 for Mac doesn't understand this data connection, so if a Mac user edits and saves the file, it strips the data connection from the table. The previous data is still stored in the table, but I can no longer refresh it even from Windows.

Is it possible to re-connect the data connection to the table?

  • I can't just re-create the table because all the references to the table would be lost.
  • I tried converting the whole table to a range, then using "Get external data from Access" on the entire range of cells, but Excel simply shifts the existing data to the right (and all the references in the spreadsheet still reference the original data instead of the new table).
share|improve this question
    
Does the other person have the same data connection to the database set up? Typically you need to setup an ODBC with MS Access drivers to make the connection. If they don't, it won't work and will drop the connection when they save the file. –  CharlieRB Dec 31 '12 at 20:43
    
@CharlieRB It's not an ODBC connection, the connection type is "Microsoft Access Database" (the provider is "Microsoft.ACE.OLEDB.12.0") –  Stephen Jennings Jan 4 '13 at 22:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.