Dont open both Tableau workbook and Excel file which is connected to Tableau workbook.
If you open both at a time if you made any changes in your excel data the excel wont save with the new data..
Close the Tableau workbook and open the Excel file and change what you want to change in Excel file and Save the file.. Now your Excel will save with updated data..Then you can open Tableau workbook and can do refresh in ur Tableau Workbook...
Hope dis helps you...
Thanks for your help.
This has already been ensured by me.
Everything is fine in tableau desktop, the only issue is with server and
that too in a particular time of the day.
The connectios are live.
On 30-May-2017 11:15 AM, "Sravan Yadav" <email@example.com>
The issue was because of the file being shared with others. We ensured only the workbook owner have modify access to the file and then it worked out.