How to get automatic data that will update for foreign users.

ClownBoi

New Member
Joined
Oct 27, 2023
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello -

I’ve been tinkering around with a sheet at work and I’ve been using various sources for getting data into a specific sheet so a group of 50 people can use.

The best way I can query my data is through Microsoft exchange and applying filters to a specific email with excel attachments.

Problem I have is: how do I make this query public so even though it’s pulling from my email, how do I make it pull from the email of whomever may open the file so it can auto update the DB.

I can do it for myself no problem but anyone know of a way to kind of have it pull from a server or something? So everyone can have up to date data?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,224,813
Messages
6,181,107
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top