Share the same Excel document

  • Thread starter Thread starter MGadAllah
  • Start date Start date
M

MGadAllah

Hi
Me and another user at my work need to share and access on the same
Excel document at the same time. We are using Excel database such as
Pivot Tables. Any way or another 3rd party to do the job? I want to
have a full functions for the Excel.
Thanks
 
hi
in excel help type "share a workbook". read up on how to create, how it
works and resolving conflicks. the only conflick i'm aware of is if 2 users
happen to save the shared wokrkbook at exactly the same time. but access has
that problem too when two users try to update the same record in the same
table at the same time. meaning not perfect but workable most of the time.

Regards
FSt1
 
But don't expect to have the full functions of Excel.

Shared workbooks lose a lot of functionality.

See Help on shared books for more.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Shared File 3
Pivot Table with MS Access as DataSource 1
Access #Error & Excel Pivot 0
Pivot tables - Editing the data source shared by multiple pivot ta 1
Checking/amending the external source link to an Access table 1
How can I change the source data reference to another pivot table? 2
From share drive particular excel file takes long time to open 0
Question on the occupied field of the pivot table in excel spreadsheet 0

Back
Top