RW pointed me in the right direction. I ditched consolidation and did cell reference, using =Sheet1!$A$1 as the code and I can at least get the numbers in there now.
However, I am unable to update them. I changed the numbers to see, and it didn't change. Is there a way to update all the cells? I used the update all tab and it did nothing. It tried to re-link and still the numbers remain unchanged.
|