How many columns can report based on Excel Template have?
Summary
How many columns can report based on Excel Template have?Content
Hello. I am busy creating a data migration extract (BI Report) that contains a lot of fields. I am using an Excel Template for this extract (BI Report). But now I have run out of Excel columns on Sheet1. It seems an Excel Template can only fit 256 column on a sheet. Is there a way to continue on the next sheet and show the rest of the fields there? I have tried doing it but my XDO_GROUP_?G_1? is not working on Sheet2 . So either is cannot be done or my reference to XDO_GROUP_?G_1? is incorrect on Sheet2. On Sheet1 the XDO_GROUP_?G_1? reference is =Sheet1!$2:$2 but when I