Any Way To Have Multiple Users Edit Excel Spreadsheet When On Company Server?

Sep 25, 2013

Not exactly what year of Microsoft Excel we have at work buts its between 2007 to 2010.

Doing our weekly KPI on a friday is super stressful and if there is a way so multiple users can edit the excel spreadsheet at the same time?

Because with our excel spreadsheet only one person can edit the document at a time very frustrating at the end of a day on a friday.

Is it just Microsoft not allowing more than one editor at a time?

View 1 Replies


ADVERTISEMENT

Multiple Users To One Spreadsheet?

Mar 5, 2013

We have a place where all our documents are stored. We have a log where we all log in what we're working on. Our trouble is, if one person has it opened nobody else can add their items to it. Is there anyway to have multiple people be able to open and enter their work for the day, save and close it out?

View 1 Replies View Related

Add-ins & Multiple Spreadsheet Users

May 29, 2009

I've created a model that uses an add-in to calculate otherwise cumbersome formulas, and 4 or so people need to access this model at any given time. It's saved (along with the add-in) in a public folder on our network drive. Everyone is able to access the model, and is able to load the add-in directly from that folder, but the cells that use the add-in point to where the add-in is stored locally on my drive (C:Documents and SettingsmeApplication DataMicrosoftAddIns) and thus they are not able to use the add-in functions without redirecting every reference to me with references to their add-ins (basically just by finding and replacing every 'me' with 'them' in those cells at this point). So I guess what I'm wondering is how do I make it so the add-in is 'universal' (instead of local) such that as long as each user has the add-in loaded they can fire up the model and use the needed functions.

View 9 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

Share Spreadsheet With Multiple Users

Sep 11, 2007

I have a speadsheet, and at the moment, another spreadsheet access it via a vb code. but i have 3 - 5 agents needing it sometimes at the same time. All that happens, is the agents excel sheet passes some info to the server sheet, so the vb codes opens and closes it. So only one person can do it at the same time.. but i need this so anyone of the agents can enter info via the vb code.

When i tested it, it asked me when i opened it, if i wanted to save what the last person did, I need that not to come up, so really its like the sheet is always open, but not... and lines are added. The info is added to the same sheet, and line by line.

View 2 Replies View Related

Excel 2007 :: Edit Query From Spreadsheet

Apr 11, 2012

I have recently installed excel 2007 how do you edit and ODBC query from the spreadsheet. In 2003 you right clicked on a cell that opened a dropdown where you selected edit query.

View 1 Replies View Related

Use Data Entry / Search / Edit For Spreadsheet On Excel

Aug 9, 2012

I have created an example of a "Waiting List" for the college, everything I had done seemed to be working before I left for my holiday (apart from the search facility as I was still doing some problem solving, compiling and coding for it).

The Idea is to : Open Excel Document and be greeted by the "Hello" Userform

[Problem #1: This does not automatically show since I have returned from holiday, though there seemed to be no problem with it prior my escape.]Choose from three options;"Save and Exit" saves any changes on/in the database and closes the document"Insert Data" opens "Userform1" to allow users to enter a new row under the exsisting rows of data.

[Problem #2: The data in the sheet was all entered using this feature, but yet again since I have returned from holiday it keeps adding the data only on row 2]

[Problem #3: How to do Auto Formatting i.e. Postcode in Capital Letters]"Search" will open the "Search" userform which I hope to allow users to choose up to three column headings and enter the value to search that column with the parallel textbox value.

[Problem #4: The data which meets the criteria the most is listed into the listbox, if you select a piece of data (double click or "selected") it opens a new userformThe "Edit/Enrol" Userform allows user to Edit, Enrol or archive the row of data.the last Userform I created "Course" is for an admin of the workbook to choose a course and it be auto populated by the information in the worksheet "Code" and create a Mail Merge.

View 9 Replies View Related

Allow Users To Edit Ranges?

Jan 2, 2014

I have a sheet which has many columns in it, all columns are protected except column B. When I want to enter data always I have to insert a column in column B. When I clicked insert button, my B column move to C and B column become protected and C become unprotected. My query is always I want B column should be protected (even if i clicked on insert column button too).

View 1 Replies View Related

Send Text Msg To Peer/peer Vbnet Users Without Server

Jan 26, 2008

I needs to send one way text message to pop up on my student's screen. THey don't have office installed but my vb net2005 program. My network is just a simple peer to peer. Can I do this by just using tcp/ip and not installing any other service?

View 11 Replies View Related

Allow Users To Edit Ranges Not Working After Running Macro?

Feb 14, 2013

I have a sheet that I have added protection to (Tools / Protection / Protect Sheet) with a password (PostItNote). Before I protect the sheet I have allowed users to edit ranges (Tools / Protection / Allow Users To Edit Ranges). I have made my selection of the cells that users are allowed to edit and protected the sheet. I now want to run a macro that will un-protect the sheet (in order to allow the macro to edit the protected cells) make some changes and then re-protect the sheet. The macro runs as it should do but when it stops I am unable to edit the cells that I allowed users to edit? For some reason the areas that I enabled users to edit have been changed allowing users to only edit far less cells that I originally set!

Here is my macro code that I am running:

[Code] ......

View 2 Replies View Related

Spreadsheet That Keeps Track Of Annual Expenses For Company Car

Jul 25, 2012

I need to design a spreadsheet in Excel that keeps track of annual expenses for the company car, but have no numerical data.

The only information given is the labels needed to be used, such as main heading, date, mileage, petrol, maintenance, registration, insurance, subtotals, averages and main totals. I've designed the spreadsheet with date - subtotal at the top of each column, with total and averages on the left hand side, under all the months (so the answers to both the total and averages would be in each column)

I also need to write a formula to work out the averages of everything and the formula I thought would be right is giving me this error message: #DIV/0!

View 2 Replies View Related

Outlook For Multiple Users Or Excel?

Apr 23, 2013

I'm trying to identify a way of setting up a booking system for some meeting rooms we have at work. Always looking for a way of simplifying something that soaks up one of my colleagues time.

I read this post about a golf booking system and it looks like it could be adapted to suit, I can imagine a different worksheet for each room and the fields for entry on choosing the timeslot being the meeting title, who booked and a contact number and the slot showing the meeting name when hovered over possibly.

I noticed a similar thread about Outlook, I know nothing about this sort of stuff within Outlook and not sure it may be possible. I am just in my infancy with hyperlinks and macros and do not feel confident enough to start there as I do not know where to begin. Keen to learn and would love to figure out and play around within a program; learn best this way.

View 6 Replies View Related

Multiple Users In Excel File?

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 4 Replies View Related

Prevent Users From Edit/change Formats Of Unlocked Cells

Sep 30, 2007

I have a spreadsheet that is very large and formated a certain way. I want to make sure that a user cant put the cursor in the lower left corner and copy cells by dragging, copy & paste, or do anything other than input data and be able to highleght text and reinput data in case they mistyped or misspelled the data.

ex: user clicks on cell E33 and types in '1234568' and then move to next cell. The user can click back on E33 and can correct by retyping. That is all the user is allowed.
The cells in question are also in ranges if this helps. EX: 'E33:AJ67'

View 9 Replies View Related

Protect Sheet Allowing Users To Format Rows/Edit Objects?

Nov 16, 2009

I want my macro to protect my sheet again after it is done to allow editing objects and formatting rows. I am really stuck and have come up with the below, but it isn't working.

View 5 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

Runtime Error 1004 In Company Employee Timesheet Spreadsheet

Mar 9, 2009

we've been using this spreadsheet as a timesheet since May of 2002. Recently in the past couple of days when we try to update an employee's time and date of work done by clicking on an update button on the first Worksheet, an error (Runtime Error '1004' Method 'Range' of object '_Global' failed) pops up.

Clicking the 'Debug' button opens a window up with this information:

View 14 Replies View Related

Edit Multiple Excel Files Simultaneously?

Jul 6, 2011

I need to copy information from one excel file and paste it into the same location (A1-A1, B6-B6, etc) in many other files all at once. Essentially I have several thousand files that need to be updated right now. I need to copy and paste both the cell contents and the formatting.

View 1 Replies View Related

Excel 2007 :: Macro To Send File As PDF From Outlook To Multiple Users?

May 13, 2013

I currently have a spreadsheet setup on a Macro to send & distribute a message from an 2007 Excel file to multiple users through Microsoft Outlook 2007. It is currently setup to send as an attachment. I need to find a way to have this file be sent as a PDF file. I know you can save Excel as PDF's so there must be a way to send them & attach them to as a PDF.

View 3 Replies View Related

How To Restrict View For Users Of Spreadsheet

Feb 9, 2014

I've written a spreadsheet for others to use, protected it (except for cells where data input is required). Almost like an App for sales people to prepare quotes. I want it to appear fullscreen only with formula bars and headings permanently hidden so feels the experience for the User is similar to an App.

View 9 Replies View Related

Disallow Users From Using Fromulas In A Spreadsheet

Dec 13, 2009

Is there a way to disallow users from using fromulas in a spreadsheet? I have an issue in which users are using formulas to concat data as a shortcut to typing in data but they are constantly referencing the incorrect cells.

View 6 Replies View Related

Users Of The Spreadsheet Cannot Delete The Formula

Feb 6, 2009

I have this formula in my worksheet

=sum (L12*M12*N12)

How can i put this formula into VB code so that users of the spreadsheet cannot delete the formula.

View 9 Replies View Related

VBA Code Won't Stop Users Using Spreadsheet After Certain Date?

Jul 28, 2014

The code that I'm using is supposedly not allow spreadsheet to be opened after a certain date, or does not allow a user to press any of the command buttons and comes up with a message saying the spreadsheet is closed for new entries.But is not working for me.

I placed the Code in the ThisWorkbook module.

[Code].....

View 8 Replies View Related

If And And: If Company A (A1) And Company B (B1) Both Have Indices Greater Than 125

Jun 1, 2006

I have a nested if formula that isn't working and I know there is a real simple fix.
Here is the situation: If Company A (A1) and Company B (B1) both have indices greater than 125, I want that to show that in my recommendation. For example: I used if(A1>125&B1>125,"Company A and Company B",if(A1>125,"Company A", if(B1>125,"Company B","None"))). For whatever reason, the first nested if statement isn't working correctly. what I am doing wrong with this if/and statement?

View 3 Replies View Related

Share Excel In The Company?

Aug 14, 2014

My company has a lot of file excel. I usually use Google driver, LAN and a lot of the other ways to share file to all member in the company. But so, it is time consuming very much and not protect information in my execl file.

View 5 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

Spreadsheet That Allows Users To Select Items From A Validated Data List

Mar 25, 2009

I am making a spreadsheet that allows users to select items from a validated data list. Each item in the list has a numeric value in an adjacent column. When the user is entering data they will select from a drop down of the data list in column "A" and I would like to have the numeric value that corresponds with their selection to then autofill in column "B". I have tried VLOOKUP and IF formulas but cannot seem to get anything to work.

View 9 Replies View Related

Transpose Multiple Company Details.

Jan 4, 2010

I would like to ask how can I transpose this:
COMPANY1WEBSITE1FullnameAddressCity, State zip codetel numberdescriptionCOMPANY2WEBSITE2FullnameAddressCity, State zip codetel numberdescriptionCOMPANY3WEBSITE3FullnameAddressCity, State zip codetel numberdescriptionCOMPANY4WEBSITE4FullnameAddressCity, State zip codetel numberdescriptionCOMPANY5WEBSITE5FullnameAddressCity, State zip codetel numberdescription

to this:
COMPANY1WEBSITE1First NameLast NameAddressCityState zip codetel numberdescriptionCOMPANY2WEBSITE2First NameLast NameAddressCityState zip codetel numberdescriptionCOMPANY3WEBSITE3First NameLast NameAddressCityState zip codetel numberdescriptionCOMPANY4WEBSITE4First NameLast NameAddressCityState zip codetel numberdescriptionCOMPANY5WEBSITE5First NameLast NameAddressCityState zip codetel numberdescription

View 9 Replies View Related

How To Extract Dataset In Excel From SQL Server

Aug 22, 2013

I have a database in sql server i want to make a excel form where in a user will enter the data and print the excel file

E.g.

S.NoDESCRIPTIONPART NO

I want a user to write the item description and data should come directly from database .

View 4 Replies View Related

Excel Macro File Which Will Fetch Data From SQL Server

Sep 30, 2013

I have created a macro file which will fetch the data from sql server. Here is the code

f Me.Cmbchoose.Value = "" Then
MsgBox "Please Choose From the drop down Menu!!", vbExclamation
Exit Sub
End If
If Me.Cmbchoose.Value = "Merchants Reports" Then
Dim oConn As ADODB.Connection

[Code] .....

The code is working fine. Now my question is that I want to access it from my home. How do I do that without DSN set up?

View 5 Replies View Related







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