After uploading a workbook to onedrive, formulas do not work right away.
I have the macros linked to a Personal sheet.
Opening the workbook, get the error message to enable which I click on this.
Then keying in numbers into the sheet, a simple A * B formula does not work. That is until I get the next error message: UNABLE TO REFRESH We couldn't get updated values from a lined workbook. Understand that no formulas link to any other workbook, only the macros in the Personal workbook. Once I clear this message, the formulas work.
Anyone know a way to fix this. A user would have to wait 30-60 seconds to be able to use the spreadsheet. I have also attempted to adjust the queries & connections, which did nothing to solve this issue.
I have the macros linked to a Personal sheet.
Opening the workbook, get the error message to enable which I click on this.
Then keying in numbers into the sheet, a simple A * B formula does not work. That is until I get the next error message: UNABLE TO REFRESH We couldn't get updated values from a lined workbook. Understand that no formulas link to any other workbook, only the macros in the Personal workbook. Once I clear this message, the formulas work.
Anyone know a way to fix this. A user would have to wait 30-60 seconds to be able to use the spreadsheet. I have also attempted to adjust the queries & connections, which did nothing to solve this issue.