Use VLookup function in the excel profile to grab the information on SharePoint online

We use the following V-Lookup formula to capture data in SharePoint documents. When the SharePoint profile is removed, Excel still scrapes the old data. Wondering if this is a product design or a problem with Formula?