Hello,
I have an Excel spreadsheet where I retrieve real-time stock data and applied filters. For instance, if the stock price drops below a specified value or percentage, I want to highlight that in the data.
I've also generated a summary using a pivot table based on this Excel sheet, and I intend to share it with my team.
Requirements:
1. I prefer that my team can view the pivot table only without access to the underlying data sheet.
2. I aim to publish this online to streamline sharing without distributing the file.
Please provide guidance.
Thank you.
I have an Excel spreadsheet where I retrieve real-time stock data and applied filters. For instance, if the stock price drops below a specified value or percentage, I want to highlight that in the data.
I've also generated a summary using a pivot table based on this Excel sheet, and I intend to share it with my team.
Requirements:
1. I prefer that my team can view the pivot table only without access to the underlying data sheet.
2. I aim to publish this online to streamline sharing without distributing the file.
Please provide guidance.
Thank you.