Forum Discussion
Solved
Pulling data from one tab to another
Hello, I was working on a spreadsheet that is uploaded to SharePoint. I download the file so it's opened in the excel app instead of trying to update it from the web.. I was pulling data from...
- Is the cell formatted as Text? That would cause the formula to display rather than the result.
Kindly ensure you don't have many Excel workbooks opened... If the issue persist, just close the workbook and reopen.
Furthermore, if you're referencing many cells across sheet tabs, kindly use the group sheet technique
Furthermore, if you're referencing many cells across sheet tabs, kindly use the group sheet technique
Abiola1 Hi. That was a really great thought... I just tried again, made sure the only thing I had open was Excel (for good measure I closed every program I had open) and it still won't work. It just shows the formula in the cell =Active!O41. I've also tried ='Active'!O41 and that doesn't work either. There is no "formula suggestion" either. It really is the strangest thing because I know I'm not doing anything wrong...
- Is the cell formatted as Text? That would cause the formula to display rather than the result.
Wyn Hopkins THANK YOU SO MUCH!!! OMG that fixed it! Happy Friday and Thank you!!
