Updating data in excel automatically

With Windmill data this equates to the number of rows of data (and headings).

updating data in excel automatically-9updating data in excel automatically-32updating data in excel automatically-10

The trick here is that a named range can be defined using a formula.

The problem comes that when I open the XLS file, worksheet Invoice never gets updated with the new values in Invoice Data.

I either have to 1) Save it as a new fileor 2) Hit CTLSHIFT F9 Writing a macro is not an option because the business requirements say the XLS file can not contain a macro.

We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.

Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.