Forum Discussion
Excel Onedrive PrevSheet Formula
I have been using the =PrevSheet formula in my Excel workbook. I have all macros enabled in the Trust settings. But after uploading this workbook to OneDrive, I am getting the #NAME? error. Why does it work when the workbook is on my computer and not when I access it through OneDrive? How can I fix it?
1 Reply
If you open the workbook in the browser, VBA code won't work, so you see #NAME!
If you open the workbook in the desktop app for Windows or Mac, the function should work.
If not: what is the code of your PrevSheet function?
