I've back-filled certain historic pension transactions into my srcTrans sheet. After doing so, I checked my psconfig file carefully and I don't seem to have any error files in the C-drive PSData folder, however, when I update the PS workbook I get the following error message:
'We couldn't get data from the Data Model. Here's the error message we got: Cannot create relationship from the 'Symbol' table to the 'Allocation' table because the 'Allocation' column in the 'Allocation' table has duplicate values.'
I have checked my allocation table in src sheet and there is no such duplicate showing. However, I do think the error might be arising from some sort of update issue linked to the src sheet as I renamed the portfolios (cells B11 onwards) when doing the back-fill exercise but the updated names have not fed through to the other sheets (e.g. the dashboard).
Any ideas what is going on here and how to resolve it?
Thanks - and Merry Christmas!