Forum Discussion
Solved
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...
- 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.
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- When I do the formula you suggest it returns a single cell of "1/0/1900"
- [Create a 3-D reference to the same cell range on multiple worksheets - Microsoft Support](https://support.microsoft.com/en-us/office/create-a-3-d-reference-to-the-same-cell-range-on-multiple-worksheets-40ca91ff-9dcb-4ad1-99d2-787d0bc888b6) could be relevant too for your task.
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.
- Doing this resulted in a single cell being filled with a date of 1/0/1900.
