Forum Discussion
Table not populating using VSTACK
I have multiple sheets and each sheet has a table in it. I am using VSTACK to populate a "Dashboard" sheet that combines all the tables. Every table is working, except for one. When I try to put this one table in the VSTACK it returns a single zero.
The table is formatted the same way as all the other that are populating. Why is this only table not working with the VSTACK function?
- I was able to fix the problem by re-creating the table. I found that the issue was with the formulas I was using to calculate dates (when I would copy and paste the content as plain text the VSTACK worked). So I recreated the table and reapplied the formulas for dates and it worked.
I do not know why the formulas in the first table were not working originally as they are the same ones used in the current table that is working.
- I was able to fix the problem by re-creating the table. I found that the issue was with the formulas I was using to calculate dates (when I would copy and paste the content as plain text the VSTACK worked). So I recreated the table and reapplied the formulas for dates and it worked.
I do not know why the formulas in the first table were not working originally as they are the same ones used in the current table that is working.Great to know you solved an issue. I'd join to JKPieterse - if you have desire and time that will be quite useful for other people if you could share more details as sample file or so.
EllenC53715 I would love to be able to see your problem file. You can replace all data with nonsense. I'd like to see where exactly things go wrong.
- Can you show us your formula please? Are you sure the # of columns are equal for all sheets you're referring to?
- Yes there are the same number of columns in all tables.
=VSTACK(Table1, Table2, Table 3....)- Is the offending table empty by any chance? Or perhaps the table doesn't span the expected range of cells?
I may need to see the sheet, but I'd start by isolating the problem table. What happens if you try to spill that table?
For example:
- When I spill the table it still populates with a single zero
- If the range the table is looking at looks good (more than 1 cell), then I'd try converting the table to a range and then convert back to table.
- Any clue when you view the tables in the Name Manager? Would be helpful if you could post the details from Name Manager.
Since it has a space, could you wrap it in single quotes ='Badgers Belong Day 2'!A1:J30.
I just tested it in the web version of Excel, it does accept the name when you enter it without quotes, whereas in desktop version will not allow it. Anyway, while in Refers To, it is easier to navigate to the sheet with the range and select it. Then you will get correctly formed reference.
