Unable to refresh linked data table
I am using excel as my datasource and i have to apply a join based on the multiple excel file. I have created a join based on the major excel data and joined other table.
When i am trying to refresh the raw data the data is refreshed but when i am trying to refresh the table on which i have made a join, it gets stuck in Inserting Columns and nothing happens after that, i am on the screen for more than an hour but no changes.
Also i checked the data table properties on the join table, i see a message "Update behavior: Automatic (not applicable; data is stored for this source)" on the source information.
Can you please help me in resolving this, i dont know what is wrong and how can i correct the above mentioned error.