VBA not updating formulea

[dnorm]

Hi All

I have a VBA project that on button activation opens 2workbooks (Data sheet and PPM tracker). The main workbook (report) has formulaethe links to the Data sheet. When I open the workbooks backwards manually (datasheet then Reports) the formulae updates. The Formulae I am using are similar tothis:

=SUMIFS('\\CSHFS002\Dept$\Quality\07 Reports\02 DataDownloads\[Data Download.xlsb]1. ScrapTransactions'!$M:$M,'\\CSHFS002\Dept$\Quality\07 Reports\02 DataDownloads\[Data Download.xlsb]1. ScrapTransactions'!$A:$A,Report!D1-1,'\\CSHFS002\Dept$\Quality\07 Reports\02 DataDownloads\[Data Download.xlsb]1. Scrap Transactions'!$M:$M,">0")

The VBA is complex as it is (for my understanding) and I donot know how to add formula like these to the VBA to get it to work in themanner I want.
The Report looks across 3 sheets for update on the Data sheetand then updates the PPM tracker sheet.

I have tried now for 3 days to fix this without any success,any help would be grateful.
I have swapped “\\chsfs002.. “ for the drive letter, stillno joy.