Using Workbook By More Than One Users At Same Time

Jan 8, 2012

can we use excel workbook by many users at same time ?.

View 3 Replies


ADVERTISEMENT

Function To Be Added On Timestamp Macro To Align Time Of Users From Different Time Zones

Mar 28, 2014

I am looking for a function to convert time given by my computer (Local time) in EST (Eastern Standard Time). We are several users of a same file (with timestamp macros) and all time need to be aligned to one time zone (EST), even if all users are working in different time zone (EST, CST and IST).

View 1 Replies View Related

Multiple Users On Same Spreadsheet But One Tab At Time?

Jun 13, 2014

Is it possible to allow access to multiple users on one spreadsheet but they can only access one tab at a time each?

prevent multiple changes for the same thing.

View 1 Replies View Related

Use Of On Time To Kick Inactive Users

Apr 16, 2014

I use the 'on time' function to kick users out of a shared workbook after 30 minutes of inactivity (i.e. no cells updated). Technically it works, as it does kick out the users.

However the time after which it does so seems to bear no relation to the time I have instructed. Sometimes shorter, sometimes longer! If it is was always longer, I would be happy that there is an error in my code somewhere (i.e. the time value is resetting on an unexpected event that I need to find and alter).

View 6 Replies View Related

Multiple Users In Excel File At One Time?

Aug 1, 2013

I was wondering if it's possible for several users to be working in an excel file at the same time? I know that 1 person can be working in a file & other users can look at it in Read-only, but is there any way for more than 1 user to be WORKING in it at a time?

View 3 Replies View Related

Stop Users Changing Computers Time/Date

Aug 31, 2006

I am creating time sheet application , obviously i need to store the time when the user logs & logs out .. The issue is, the user can "Cheat" by changing the system time ...

Any alternatives?? Is it possible to store the time from a particular server etc or some other source.

View 9 Replies View Related

Calculate The Total Time Users Spend On A Spreadsheet Per Month

Aug 10, 2009

I have a simple VBS script that puts the username & current time in columns. When the user saves that time is also placed into a column.

I would like to be able to calculate the amount of time a user has spent on the spreadsheet for the current month & if possible the total time all users have spent on the spreadsheet this months.

View 8 Replies View Related

Share The Workbook With A Number Of Users

Apr 3, 2009

I have a workbook, that has a lot of VBA code, & Userforms. I need to be able to share the workbook with a number of users.

View 13 Replies View Related

Removing Users When Saving Workbook

Aug 2, 2006

I am running code that updates several excel sheets from a database, but quite often other users on the network are already in the sheets, is there a way i can remove the users just before the macro saves the file? Or alternatively saves it to the new filename whether or not someone is in it?

View 4 Replies View Related

Use Vba To Create Copies Of Excel Workbook For Different Users?

Nov 26, 2012

I have an excel workbook that serves as a master workbook. I have to create 30 copies of this workbook, 1 for each site. Each workbook will have small differences in the data held. This is because I will refresh the sheet before saving it. There is a dropdown list on the 1st tab of the workbook that contains the names of the sites. The sequense, I suppose would be like: select the next name on the dropdown list"calculate" the spreadsheet to enable the refreshsome sort of "save-as" with the name from the dropdown list forming the name of the file. The Master file must be kept intact.select the next name from the dropdown listcalculate the sheet ........and so on I have a few other things I will add to the script like Protect Sheet etc.

View 1 Replies View Related

Save Workbook To Folder Chosen By Users

Aug 16, 2007

I have a summary workbook that I want to save into different folders designated by the input from my userform. My directory has folders named: "A051 - Watson", "A052 - Gila Bend", "A065 - Tompkins"... etc; but I want to designate which folder to put the summary workbook in by the first 4 characters in the folder names(A051,A056,A055...etc) Let me know if I made it clear enough.

View 4 Replies View Related

Shared Excel Workbook Shows Different Information For Users

Mar 3, 2014

We have a Shared workbook on our Server and about 5 users work at the same time every day. I want to understand something, If I open it I can see all the information in it, all the rows and so on, but if the same workbook is opened by another user he will see other information, the rows aren't the same as in my case. Why does this happen ? I would like the second users to see the same information as I do.

View 1 Replies View Related

Data Validation Dropdown Menu But At Same Time Allowing Users To Enter Free Text

Nov 15, 2010

Is there a way to have a data validation drop down menu but at the same time allowing users to enter free text as well.

View 3 Replies View Related

Sharing Workbook With Multiple Users Entering Data Simultaneously

Feb 2, 2013

My Workbook contains several UserForms in which employees will be entering hours and activities on a daily basis. In the UserForm, they select their department and enter hours for each specific type of work/activity that shows up for that department in the userform. They click the submit button and all the data (date, name, department, type of work and hours) is added to a database table in another sheet, which in turn feeds a number of reports.

I need to be able to have anywhere from 20 to 100+ employees enter their hours on a daily basis, many of them at the same time, all from different locations (within the network of the client's system), using the same UserForms.

We've experimented with Google Drive, but that seems not to be the solution. It kind of works, but is not secure (it installs a copy of the entire workbook on the users system and then synchs the data back to the server upon "save") and way too cumbersome. I've heard of SharePoint, but not every client has that installed (and frankly I don't know how it works).

View 3 Replies View Related

How To Intimate Other Users About Editing Record In Shared Excel Workbook

Jun 2, 2014

i have an excel database regarding about 1000 different schemes having the details of their initiation date, budget allocated , up to date expenditure, this month expenditure and many others too. this is a shared workbook and relevant officers enter their data in their relevant columns and rows. the file is shared. now i want that any changes done by mr. A, for eg. at record No. 09 could be intimated to Mr. B who is working at record No. 560. may be via msg box or any other source.

View 1 Replies View Related

Macro Button Disabled When Workbook Date / Time Created Different Or More Than Time Set

Mar 7, 2014

I have a workbook with macro button to run some vba, if i want the button to disable when the user make copies of the workbook (date created is later than original wb saved time) what codes to add in the VBA?

what i assume is to add the time to a cell when the wb is saved, when the wb opens, it check for that cell if the same with the date created, if different, then disable the macro button.

View 9 Replies View Related

Excel 2003 :: Unable To Allow Users To Make Changes To Workbook But Only Be Able To Do Save As Not Save

Dec 3, 2012

I have an expense report, which was originally done in Excel 2003. It still prompts users to open as read only however if they select no, they are not prompted for the password, and it has allowed them to save, so when the next person opens it, they have the previous person's report instead of the clean workbook. I have tried everything to put a password onto it. I know this is really basic stuff, but maybe I am missing a step? I want the end user to be able to make all the changes they want in read only mode and then do a save as, but if the select No when prompted "Open as Read-only?" they should have to put a password in.

View 4 Replies View Related

Share Workbook With "Allow Changes By Multiple Users" Code

Aug 8, 2007

Although i am using VBS, the coding should be similar. I am looking for all Excel files in a folder (WORKING) and determining if they are shared, allowmultipleusers, (WORKING). The problem I am encountering is changing the Excel workbook to a [SHARED] workbook. By that I mean Multiple users can open and make changes. What is the syntax to enable that? As an FYI I can save the [SHARED] workbooks as exclusive (normal), but not the reverse. I have tried Saveas,,,,,,xlshared, but is not working. Here is the VBS code I have (For grins)

Const APPLICATION_DATA = &H1a&
Set objShell = CreateObject("Shell.Application")
'Set objFolder = objShell.Namespace("L:Shared Services Stock Rotation ReviewRotations for Review")
Set objFolder = objShell.Namespace("C:Documents and Settingsmhast14DesktopRotations for Review")
Set objFolderItem = objFolder.Self

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objExcel = CreateObject("Excel.Application") ..............

View 3 Replies View Related

Sharing Workbook And Make Changes On Excel Workbook At Same Time

Jan 23, 2012

Any way that two or more people can share and make changes on a excel workbook at the same time.

View 1 Replies View Related

Workbook Takes Time To Open

Apr 10, 2009

i have a workbook that is only 345kb in size it takes ages to open and although it has lookups and retrieves data from the web it just seems like it shouldnt be so slow

i also keep getting a message at the bottom like this:-

calculating (1 processor ) thena %

View 9 Replies View Related

Return To Certain Tab Each Time Workbook Is Opened

Nov 10, 2009

I have an excel file on a share site which is accessed by several people. The first tab is set up as a home page which directs the person to the relevent part of the work book that they need. My problem is that as the person saves their updates it also saves the location of the workbook they were in. I want it to return to the " homepage" automatically each time it is opened.

View 5 Replies View Related

Opening A Workbook At A Specific Time

Oct 2, 2007

to open a workbook at a specific time. I want to beable to flip my computer on at 8:50am, go grab some coffee and then at 9:00:00am have my workbook open and performing tasks. Besides turning on my computer, I dont want to have to open or activate anything prior to having my workbook open. However if there is code to turn on my computer from a sedative state that would be great too.

View 9 Replies View Related

How Do I Reduce The Calculating Time In A Workbook

Apr 24, 2009

I have been building a spread sheet data base which I think is pretty simple.

It now has quite a few formula's and is taking time to calculate when I add data.

I have tried to simplify some formula's and get rid of complex one's that can be replaced with simple ones... Is there any advice or suggestions for reducing the calculating time..?

View 12 Replies View Related

Find That Time In Another Sheet (which Is In The Same Workbook)

May 13, 2009

I want is when a user enters a time into a specific cell I want Excel to find that time in another sheet (which is in the same workbook) and give out the details of the cell which is next to it, see attached image file.

View 3 Replies View Related

VBA To Count How Many Time A Workbook Is Opened

Oct 27, 2010

Just wanted to ask all the VBA gurus if they would know how to put the number of times (i.e. in Sheet 1, Range A1) a Workbook is opened.

I then want to basically have the code delete every sheet if ithe count is > 50.

View 7 Replies View Related

Excel Workbook Changes Into Time Format

Jul 30, 2012

I have a excel workbook about 200kb in size. I have about 8 tables and a macro in it. Sometimes when i open it the default format changes to time format and i get values like this 00:00:00.

I have recorded a macro that will do the re-formatting for me.

View 1 Replies View Related

Open Workbook At Specific Time

Jun 18, 2008

Need to have a particular workbook open at a specific time...

I wrote this and placed it in a Personal.xls module, did not run automatically. I then placed the 2nd SUB() in the "This Workbook" and nothing. Where or how is the proper way to run this...

----------------------------
Sub Open_IndexAnalysis()

Workbooks.Open Filename:="e:Index Analysis.xls"

End Sub
------------------------------
Sub Run_OpenIndexAnalysis()

Application.OnTime TimeValue("09:40:00"), "Open_IndexAnalysis"

End Sub
-----------------------

View 9 Replies View Related

Closing Workbook At Specific Time

Mar 9, 2007

I can open a file at specific time using TaskSchedule. How do I close it at specific time?

I am trying to write a simple one-line code for that but do not know how to combine two statements:

Application .OnTime TimeValue("17:01:00")

and

ActiveWorkbook.Close

Also, this workbook is updated every 1 minute using the same OnTime method and everything works perfectly. However, when I try to close file there is a message saying that "OnTime method object application failed" and I have to click "Debug" or "End".

Only when I click "End", the file is closed.

View 6 Replies View Related

Track Time Spent Active In Workbook?

Aug 26, 2013

My team and I are attempting to track how much time we are spending in each Excel workbook we create (all workbooks are created from a single template). The problem is that we are often jumping back and forth between different workbooks throughout the day so manual entry methods are neither accurate or practical. Is there a way, with macros or formulas, to embed a time tracker in the template workbook that would only record active (when workbook is selected) time in the workbook?

View 3 Replies View Related

Excel Error Every Time Open The Workbook?

Oct 24, 2013

i get the following error everytime i open my workbook

Removed Records: Object from /xl/printerSettings/printerSettings2.bin part (Print options)
Removed Records: Object from /xl/printerSettings/printerSettings3.bin part (Print options)

ive tried everything. ive attached the workbook (obviously with all data removed).

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved