Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
errors in new migration to Version 3
Hello:
Hoping to get some insight into the cause/correction for the errors shown on the attached file. Running windows 11, 2024 Excel, 64 bit version..... if that makes any difference.
Thanks!
Hoping to get some insight into the cause/correction for the errors shown on the attached file. Running windows 11, 2024 Excel, 64 bit version..... if that makes any difference.
Thanks!
Comments
In such cases I do following:
1. Make a copy of your PortfolioSlicer-Source.xlsx file. Save it in different folder as you will have to restore it later.
2. Remove last 50 transactions from your PortfolioSlicer-Source.xlsx file (the file in original location that is used by script) and try run scripts again. If scripts work OK, copy back original file and review these 50 transactions and try figure ouw what could be wrong with them. Maybe date is not date, numbers have other characters, etc.
3. If step 2 did not fix problem, delete another bunch of transactions and check if after that refresh works. If works, then just like in step 2 restore back original file and maybe remove less transactions and try figure out what is wrong with these transactions that start working after removing them.