Hello Community,
When I add an Excel file to OneDrive, I cannot "Create a table", because of the following error.
What I can do?
FLOW
FLOW ERROR
Thanks, but it didn't work for me.
I just defined a large row number and then used filters.
I didn't realize that your table is not at the top of your sheet.
If your table is always starting at Column B and row 8, then this formula should work for you. However, this assumes you have no extra non-table data to the right of the table data and below the table data.
=$B$8:INDEX($8:$1048576,COUNTA($B8:$B1048576),COUNTA(8:$8)+1)
Thanks for answering.
Excel already contains data, but it is not in Table format.
I tried the formula you said, but it gives me an error.
What formula can I apply for the Excel image?
Does your new Excel file already contain the data, and you are just trying to turn it into an Excel Table? Or is the new Excel file completely blank and you want to create a new blank Table?
If it already has the data in it (including the headers) then try this instead.
=$A$1:INDEX($1:$1048576,COUNTA($A:$A),COUNTA(1:$1))
Hi @fgonzalez515 ,
The issue is Create table action does not except excel formulas to create a table range, such as =offset.
Excel Online (Business) - Connectors | Microsoft Learn