Dear reader,
When I try to calculate a workbook, it does not fully calculate all the formula's (I download the file (binary data) after calculating), however I don't receive an error. I can't share the xlsx. files, but I know that there are not external links, no macro's/VBA, no loops, no dependencies on Excel versions past Office 2019. The excel sheet calculates perfectly fine on my desktop, so I have no clue what could cause this issue.
One thing that caught my eye:
Three cells have a VLOOKUP formula, but the cell says:
<r xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><t>T</t></r><r xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><rPr><i /><vertAlign val="subscript" /><sz val="10" /><rFont val="Arial" /><family val="2" /></rPr><t>core</t></r>
Things that I wonder:
Kind Regards,
Nadine
I have identified the issue! I was creating a stripped down version of the excel workbook to share my issue on this forum, when I discovered what was causing the issue: In each workbook, there was a VLOOKUP in which one of the cells in the VLOOKUP range contained text with subscript. When I removed this subscript text, it calculated it perfectly fine. If I added it in, I got the error as mentioned above in the VLOOKUP cell.
I don't know if this isssue is supposed to occur, but I am happy I have managed to resolve it. I hope you can check it out and possibly resolve it for the future!
Great! Glad you found the issue and resolved it.
There are some limitations with formulas in Advanced Excel and I guess you found one of them :)
Thanks for sharing the solution!
Hanno
Hi Nadine,
Would it be possible to post a copy of the spreadsheet and also comment on which cells (row & column) you notice are not calculating? This will make it quicker & easier for the team to investigate.
Kind regards,
Stuart