Oct 30 2019 11:29 AM
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 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!
Krystal
Oct 31 2019 01:15 AM
Oct 31 2019 03:47 AM - edited Oct 31 2019 03:49 AM
Oct 31 2019 06:05 AM
@Wyn Hopkins No, I am not working with excel on the web. I check-out the file, then "open in Excel", so I am not editing the file from the web.
Oct 31 2019 06:13 AM
@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...
Oct 31 2019 03:27 PM
SolutionNov 01 2019 04:52 AM
@Wyn Hopkins THANK YOU SO MUCH!!! OMG that fixed it! Happy Friday and Thank you!!
Oct 31 2019 03:27 PM
Solution