Go to [Developer] > Macro Security. Under Macro Settings click Enable all macros.
The bars in Gantt chart are not stacked
An incorrect selection of chart type
Right click on the chart and click Change Chart Type. The Chart Type window appears. Go to [All Charts] > [Bar], then click Stacked Bar. Click OK to accept change.
My original tables have dissapeared after merging
You have saved the merged table to a different sheet or file
Switch Files or Sheets
I have updated my tables but my merged table has not updated
Merged tables do not update automatically
Manually update by clicking refresh on the merged table in the Queries & Connections toolbox