OneDrive Help

[OhYouDidntKnow]

Hello, I am not sure if this is the correct place to post this but I am having trouble finding somewhere to ask these questions.

I am trying to publish my excel file to my one drive account. However, for some reason one drive isn't pulling all the data. My file has a few formulas that's pulling from other tabs on the sheet. Some of the formulas work fine but some won't work at all. I have used a sheet extremely similar to this and posted on one drive and the formulas worked fine. However, now it won't fully work.

Any ideas?

[MarvinP]

Hi OYDK,

I'd suspect the formulas that pull from other workbooks have a path on where to find those files. When on OneDrive the path may have changed or not be the same when on your own hard drive. This might be the problem that keeps these formulas from working. This site might help.
https://support.microsoft.com/en-us/...7-3833539def0b

[OhYouDidntKnow]

Hi OYDK,

I'd suspect the formulas that pull from other workbooks have a path on where to find those files. When on OneDrive the path may have changed or not be the same when on your own hard drive. This might be the problem that keeps these formulas from working. This site might help.
https://support.microsoft.com/en-us/...7-3833539def0b

Hi thanks for your response. Unfortunately, nothing on that link seemed to help with my issue.

The formulas are all still the same when I open it in one drive but it's just not pulling the data and I have no idea why