Want to create and post an Excel price sheet online using Office 365

Myhobohemia

Board Regular
Joined
Mar 12, 2020
Messages
54
Office Version
  1. 365
Platform
  1. Windows
Hello everyone. My company receives a weekly email with a button ("For updated prices click here") which takes you directly to this online price sheet: Assure Dist price list as of 08272020.xlsx

I want to reproduce that same functionality to share OUR prices. It would be great to be able to share updated prices in real time like this.

My vast ignorance on how to do this breaks down into two main areas:

1) How to create a formatted, protected Excel suitable for posting online. I'm hoping this is as easy as it sounds. Do I just mess around with an Excel until I like the way it looks, and then protect it? Or is there anything else I need to know? No idea, never done any of it.

2) How to post it online using OneDrive. This is what I most need help with. I've never seen this functionality with Office 365. I wonder whether it's possible. Won't it always be password protected? To date, my colleagues have problems opening my One Drive links, and we all have the same Office 365 Business account. And they still get blocked/ get asked to put in passwords at unexpected times. I want someone to be able to click on the button in my email, and land directly on the price sheet, with nothing in the way. Can I do that? If so, how? (Using Google Drive is out of the question, sadly).

Thanks in advance for anything that could be point me in the right direction.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Myhobohemia

Board Regular
Joined
Mar 12, 2020
Messages
54
Office Version
  1. 365
Platform
  1. Windows
Hello again. I've narrowed this down a bit. This is what I'm trying to do. I can get it to publish following these instructions. But something is wrong with the permissions.... no one can open the link. That's the issue.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,930
Messages
5,545,083
Members
410,652
Latest member
Zot
Top