#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default workbook qustion

I have a share drive that contains some files that need to be able to be
edited by two people at the same time without the other having to close out
of the program. Also if you know of a feature of Excel to automatically save
the file to the share drive every few seconds (or whatever amount of time)
that would also be helpful; I know about Autosave and that isnt what we need
since it saves a copy of the file somewhere else for backup purposes). This
way if my associate makes a change to the file; it would update on my screen
as well.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default workbook qustion

Take a look at shared workbooks. That being said XL does not handle
conccurenty well and from my experience shared workbooks can be a bit buggy.
Additionally before proceeding with a shared workbook look at the
restrictions on shared workbooks carefully.

I personally never use shared workbooks but some people around here seem
quite fond of them. Generally speaking a database is a much better solution
for sharing data...
--
HTH...

Jim Thomlinson


"brfrench" wrote:

I have a share drive that contains some files that need to be able to be
edited by two people at the same time without the other having to close out
of the program. Also if you know of a feature of Excel to automatically save
the file to the share drive every few seconds (or whatever amount of time)
that would also be helpful; I know about Autosave and that isnt what we need
since it saves a copy of the file somewhere else for backup purposes). This
way if my associate makes a change to the file; it would update on my screen
as well.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A Challenging Charting Qustion - Are there any Brainiacs Among Us? Ken Newberger Charts and Charting in Excel 2 November 27th 09 10:47 PM
one qustion ri_mirko Excel Worksheet Functions 1 June 4th 08 08:32 PM
Newbie Qustion- how to divide sum of series by half? [email protected] Excel Discussion (Misc queries) 2 May 15th 06 01:16 PM
Calculation Qustion Goofy Excel Worksheet Functions 1 March 6th 06 04:48 PM
Select sheet tabs in workbook & save to separate workbook files stratocaster Excel Worksheet Functions 2 March 1st 06 04:35 PM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"