Real-Time Data - Best Method?

L

Legacy 197620

Guest
I am starting a project with excel, access, etc.

I want to know if this is possible through excel:

One main spreadsheet with different sheets having multiple users accessing the file and it updating in real time.

-Or-

Multiple spreadsheets for each user and each can read from each other and update in real time.


And any insight/helpful links would be awesome.

Thankyou

- Matt
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,267
Office Version
  1. 365
Platform
  1. Windows
Matt

Access is built to allow multiple users.

Whether it would be appropriate for you is hard to tell without knowing why there are multiple worksheets.

How are they linked?
 
L

Legacy 197620

Guest
There doesn't necessarily have to be multiple sheets, it would just be useful.

Each sheet could be assigned to each person and every person could view each others sheets updating in real time?

All systems are linked through a network drive, so the file can be virtually accessed from anywhere.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,267
Office Version
  1. 365
Platform
  1. Windows
What I'm wondering really is will each person basically be working with the same data as everyone else.
 
L

Legacy 197620

Guest
Yes they will be, is there a different method youre thinking of?
 

Watch MrExcel Video

Forum statistics

Threads
1,127,331
Messages
5,624,061
Members
416,008
Latest member
PETE91

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
Top