Hi everyone, first post on here but have been using this site for everyone's great knowledge.
I have started using a system that will automatically update excel with the most current data from a report so it is ready to go when I walk into work. I set up a few simple formulas to look up to this data (vlookup and direct cell references) but I cannot get excel to recognize that new data has been input in the workbook. When I open the workbook non of the formulas are updating, I double checked to make sure it was on auto calc and even hit Calculate now and nothing happened. The only way I was able to get the formulas to run was to copy and paste all the data over itself. This is kinda ruining the whole point of my automated system because I shouldn't have to be doing anything at all to the workbook. Its like excel doesn't know that anything has changed.
Has anyone run into this issue, I tried searching but with no luck.
Automated System: DataWatch
Thank you in advanced
I have started using a system that will automatically update excel with the most current data from a report so it is ready to go when I walk into work. I set up a few simple formulas to look up to this data (vlookup and direct cell references) but I cannot get excel to recognize that new data has been input in the workbook. When I open the workbook non of the formulas are updating, I double checked to make sure it was on auto calc and even hit Calculate now and nothing happened. The only way I was able to get the formulas to run was to copy and paste all the data over itself. This is kinda ruining the whole point of my automated system because I shouldn't have to be doing anything at all to the workbook. Its like excel doesn't know that anything has changed.
Has anyone run into this issue, I tried searching but with no luck.
Automated System: DataWatch
Thank you in advanced
