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 one tab to another using =, then going to the tab I want to pull data from, selecting the cell, then hitting enter... So it looks like this: =Active!D41.. (Active is the name of the tab, D41 is the cell I am referencing...) It's worked over and over and over until all of a sudden it stopped working!! Strangest part is when I go back to the cells that already pulled the data and re-enter the formula, it's no longer working for that either!! So incredibly strange!! Anyone know whats happening? Are you only able to pull over a certain amount of data from one tab to the next?
Any help or advice would be appreciated! Thank you!
@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...