I have a excel worksheet that reads data from a csv file that gets generated by a different program. When I open the worksheet it makes me open the csv file before it will update. Is there a way to eliminate this inconvenience? The cell vale for the worksheet looks like this: =PLOTTER.CSV!$E4 Also is there a way to enable pivotable to automatically update or at least create a button that will make the update process easier.