Forum Discussion

Vikas Sareen's avatar
Vikas Sareen
Copper Contributor
Jul 23, 2018

Table in Excel sheet connected to access database not updating when new fields are added in the DB

I have an excel sheet with few tables (stacked bottom of one another with a running total)connected to same table in access database, each table has same columns name, I have created the tables using data wizard option in excel 2016. I have recently added new columns to the database and want to be able to see the new columns in the excel tables , when I refresh, excel gives an error message "Can't move the cells in the spreadsheet" however if I delete all the tables except the first one and click refresh it adds the new columns. Please advise what I need to do so I can see new columns in all the tables.

No RepliesBe the first to reply

Resources