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.
24 Replies
- 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.
- Any clue when you view the tables in the Name Manager? Would be helpful if you could post the details from Name Manager.
EllenC53715 Your name contains relative references. This means the range pointed to will be different depending on the location of the formula that uses the range name. IN name manager, the correct formula should look like this:
='Badgers Belong Day'!$A$1:$J$30NOT like this:
='Badgers Belong Day'!A1:J30
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.
- 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?
