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


ADVERTISEMENT

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

Assigning Editing Permissions For Different Users Across Different Columns?

Aug 5, 2014

I am putting together a corporate document which requires many different peoples access. It also requires these people to update/comment within specific columns to them.

I am really struggling with editing the columns to ensure only these specific people can access them.

Essentially I want to the document to be accessed by everyone, but column A can only be edited by Person A, column B can only be edited by Person B etc.

I've used 'Allow Users to Edit Ranges' and added a new range with a specified person - but this has not cured the problem, other people can still edit the column I'm trying to prevent them to.

Is it a case of just 'allowing' the specific person, or do I also need to 'deny' absolutely every other person to ensure that it works?

View 1 Replies View Related

Record Or Report Editing Of Cells

Dec 15, 2006

I have a need to determine in VBA if a cell has been deleted or edited. I need to perform lots of work and form entries on edited cells. I would like to just ignore deleted cells. Presently, I'm using

If Workbook_SheetChange not Worksheet Change
and loop through each cell to determine it's state and thereby its affect on my workflow.

View 4 Replies View Related

Excel 2002 :: Limitations In Shared Workbook

Jul 20, 2013

I am using excel 2002 and I have found that when the workbook is shared and getting 2 or more users to open the workbook around the same time brings up a read only type prompt box for the 2nd ( and 3rd) user when the book hasn't fully opened for the 1st user/is still fully opening. Is this a limitation within excel or is there a way around this for example via vb code.

I know the more data a workbook has can cause it open a lot slower but is this the same for shared mode.

View 5 Replies View Related

Restrict Editing To Certain Columns/Rows And Allow Some To Be Edited By Users

Oct 29, 2007

how do I restrict editing to certain columns/Rows and allow some to be edited by users?

View 2 Replies View Related

Excel 2007 :: Delete Sheet On A Shared Workbook

Oct 29, 2013

I have a file that has an original file format .xls

I saved as .xlsx (I am using Excel 2007) with a different name so I could make changes to the new file without changing the original.

That turn off compatibility mode.... but it is still "shared". While it is shared I cannot delete a sheet. In fact, I really don't even want it to be shared. If the file is open, and someone else opens it, I want it to open as "read only". I cannot uncheck the "Allow changes by more than one user at the same time. This also allows workbook merging." checkbox because it is greyed out.

View 3 Replies View Related

Excel 2010 :: Data Connection In Shared Workbook?

May 29, 2013

Im using Excel 2010 and have a data connection that I want to use. I added it to a regular workbook and it updates perfectly as-designed. However, I need this feature to work in a shared workbook, but it doesn't.

View 2 Replies View Related

Excel 2007 :: ActiveX Combobox And Shared Workbook

Jul 15, 2014

I have a workbook with a combo box.

ActiveX control? (=EMBED("Forms.ComboBox.1","") They are filled using named ranges on another worksheet and work fine. The problem happens when I share the workbook the combo boxes become completely non-functional. They don't even drop down when clicked.

View 2 Replies View Related

Excel 2003 :: Shared Workbook - Add Button To Worksheet

Aug 1, 2014

I've added some code the adds a button to a worksheet

Public Sub AddSheetPrintButton()
Dim btn As Button
Dim t As Range
Set t = ActiveSheet.Range(Cells(1, 6), Cells(1, 7)) ' button position
Set btn = ActiveSheet.Buttons.Add(t.Left, t.Top, t.Width, t.Height)
With btn
.OnAction = "sheetPrint"
.Caption = "Print Sheet"
.Name = "Print"
.Font.ColorIndex = 10
End With
End Sub

This works fine until the workbook is shared!

View 1 Replies View Related

Excel 2003 :: Inserted Row Shows Up As Hidden Row In Shared Workbook?

Nov 20, 2012

The other day I inserted a row in a shared workbook and then saved it. On my screen, the inserted row was visible and was the correct row height of 12.75. My goal was to insert the row so another user sitting next to me could enter information in the new row.

After I saved the workbook, and after the user sitting next to me saved her workbook, the row I inserted should have appeared exactly the same on her screen, but it did not. Instead, the inserted row showed up as a hidden row on her screen. It was there, but the row height was collapsed to the point of invisibility.

I repeated my attempt to insert a row which the other user could edit several times, but each time I got the same result. I could not make the row show up on her screen with a row height of 12.75.

Shared workbook in Microsoft Excel 2003?

View 1 Replies View Related

Excel 2010 :: Command Button In Shared Workbook Not Working?

Sep 7, 2010

I am using Excel 2010. I am using a shared workbook that was originally created in Excel 2003. This workbook has a command button that is supposed to be clicked to open a userform. However, I cannot even click on the button when opening the shared form in Excel 2010. When the form is not shared, the button works fine.

I have no problems with the button when opening the shared form in 2003 or 2007.

Is there anything I can do to make the command button work while the form is shared and while using Excel 2010?

View 4 Replies View Related

Excel 2010 :: Macros No Longer Work When Workbook Shared

Aug 22, 2012

Using Excel 2010.

I've created a spreadsheet at work that has two summary tabs which contain hyperlinks to around 30 separate sheet tabs.

On each sheet tab there is a list of unique values in column A (and other information relating to each value in columns B to D which are repeated for more than one unique value). In column E, users enter a test script name against each unique value they wish to 'reserve', and the macro picks out the unique test script names and via the COUNTIF formula counts the frequency of each test script name for each of the different values in column B.

My problem is that the macro seems to work fine if the workbook is not shared, but errors if the workbook is saved as shared. The error is 'Run time error 1004 - Unable to select the MergeCells property of the Range class'.

Here is the macro code:

Sub Get_Policies_Per_Script(updCol As Long, ShtName As String)
Dim rowctr As Long
Dim tgtrow As Long

Const ppsformula As String = "=COUNTIFS($A$3:$A$65000,I$24,$E$3:$E$65000,$G"

If updCol = 5 Then 'test name column has been modified

[Code] ..........

View 9 Replies View Related

Shared File Prints Differently For Different Users - Autofit Wrapped Cells

Apr 16, 2014

Here's the details:

Same file shared by many users in the office. File is maybe 2200 rows long and 20 columns wide. Last column is a text field where users can explain variances. Cells in the last column are wrapped and the rows auto-fit on the height. Zoom is set at 100%.

One person opens the file and it looks fine on the screen. Print preview also looks fine. File prints out perfectly.

Another user opens the file and it looks fine on the screen. BUT, print preview shows that the bottom line or lines of text is cut off. File prints exactly like the preview showed with clipped text.

Both users can point the file to the same printer, but that doesn't seem to change anything. Still prints with text clipped for one person and perfectly for another...

View 1 Replies View Related

Excel 2010 :: Opening Shared Workbook On Network Drive - Set Permissions?

Aug 20, 2013

I currently have a password secured excel file on my departs Q drive, which everyone can access unfortunately only 1 person can edit at a time. I tried to turn it into a workbook so we could all edit it at the same time but now some of the other users can't access the file at our other buildings throughout the county. This is for excel 2010. And I did select the share workbook, and allow multiple users to edit box. everything else is unchanged.

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

Importing Data To New Workbook Locks Original Workbook For Editing

May 24, 2006

I have created a workbook that imports data from another workbook which is used frequently on a network drive. After I import the data to my new workbook, it locks the original workbook for editing. Is there a property that will allow me to disable this 'locked for editing' read only mode or any other way to get around this?

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

Delete Sheets And Create New Workbook In Shared Workbook

Jun 2, 2014

I wrote a code in unshared workbook and it works fine. But when i make it shared i get Run-time error '1004' Delete method of worksheet class failed.

The Deleting of worksheet only occurs once (when the new wb is created) so is there i can unshare and share it back when the process is complete?

View 3 Replies View Related

Changes To Shared Workbook

May 6, 2006

I have an Excel workbook which is networked throughout our business. Its been in daily use for years with no problems. Every month I add a new sheet and to do that I untick the "allow changes by more than one user...etc". However this month the tick is greyed out and wont let me clear it. The pc's run windows XP professional with Excel 2003.

View 2 Replies View Related

Remove [Shared] Workbook

Jul 22, 2009

I have a workbook that is no longer being shared. I tried clicking on Tools > Shared Workbook. BUT i keep getting a message saying "The file C:CCTPAccountsSummary1.XLS cannot be found". Is there any way to kill this Shared workbook so I am free to modify everything?

View 2 Replies View Related

Combobox In Shared Workbook

Dec 16, 2008

Please follow the link ..... This works perfectly for me.. But it doesnt seem to work in shared workbooks.

View 14 Replies View Related

Speed Up Shared Workbook?

Aug 19, 2013

how to speed up a shared excel worksheet?

View 4 Replies View Related

Shared Workbook Saving

Mar 5, 2010

How do I get a shared workbook to automatically save upon every change by each user. The only way I can get this to work (at this point) is to run a macro that updates every 45 seconds IN EACH WORKBOOK! It's counterintuitive because the workbook is shared (on a network), but each user must start the "time" macro in their "individual" SHARED workbook to allow the automatic saving.

What am I missing? There has to be a more efficient way to do this, right?

Code below
HTML Sub Time()

Call Save
Application.OnTime Now + TimeValue("00:00:45"), "Time"

End Sub

HTML Sub Save()

ActiveWorkbook.Save
End Sub

View 9 Replies View Related

UserInterFaceOnly In Shared Workbook

Nov 16, 2006

I have a workbook that i am trying to make a shared workbook.

Shared workbooks have all kinds of functionality limitations. The one specifically giving me problems is the ability to protect workbooks.

Once a workbook is shared it's protection cannot be changed.

I protect a workbook prior to sharing and set the UserInterfaceOnly property = true (this allows my code to do whatever it wants but still maintains protection in the user interface).

Once i share and excel makes me save, everything works super and all the code in my auto_open macro works perfectly. But as soon as i close and open the file it seems that the UserInterfaceOnly property i set to true turns off and my code stops working.

Because it's a shared workbook i cannot turn it back on in the auto_open because that functionality is disabled.

View 6 Replies View Related

Charts In Shared Workbook

Jan 9, 2007

We have a worksheet, which contains charts and data which requires updating by different department.

However, when I have this work- book as a Shared workbook (Tools - share workbook), The charting and macro has all been deactivated.

Would anyone have any idea on how do I share a workbook - while being able to also update the Excel Charts within it ?

(Different user will be updating different charts, and there will be no conflict in between them)

View 3 Replies View Related

VBA Save Workbook As Shared Workbook

Aug 30, 2012

HTML Code:

Private Sub SaveAsAndShare()
ActiveWorkbook.SaveAs Filename:= _
"S:LdnPath1Path2Path32012Folder1Folder 2Aug12ReportName " & Format(Date, "MM-DD") & ".xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
End Sub

HTML Code:

ActiveWorkbook.SaveAs FileName, , , , , , xlShared

My code is the first bit, the 2nd code I found from another post, I want to add xlshared to my code above so it is shared when saved down.

View 4 Replies View Related

Editing External Workbook With Code

Jan 22, 2007

Once I open a new workbook, how do I make it the active workbook to have a function make changes to it? Problem I am having is even after it is open, the function will only make changes to the workbook containing the Macro (Thisworkbook)....

View 9 Replies View Related

Protect Workbook From Editing / Viewing

Feb 14, 2008

I have placed a workbook on a network drive. This workbook contains sensitive information and I would like to protect it to a "feasible" degree. I have written the following code

Private Sub Workbook_Open()
Dim userid As String, valid_userid As String
Dim i As Integer
valid_userid = "MISI01/"
userid = GetUserName()
userid = UCase(userid) & "/"
i = InStr(1, userid, valid_userid)
If i = 0 Then
MsgBox ("You are not authorised to use this workbook")
ActiveWorkbook.Close False
Exit Sub
End If
'create menu when workbook opens
Call Module1.CreateMenu("")
Call Modul1.check_filedate("")
' This will disable the user from moving, renaming etc the sheets
ActiveWorkbook.Protect Structure:=True, Windows:=False
End Sub

As can be seen from the above code, I check if the current userid is one of those that are valid to open the workbook. If not the idea is to tell them and close the workbook immediately (this bit isn't tested yet). This code is not supposed to be hacker proof, but to prohibit the casual user from reviewing the the data.

View 3 Replies View Related

Track Changes Without Switching To A Shared Workbook

May 21, 2009

Which version of excel allows you to do a Track Changes without switching to a shared workbook? I am awared the Excel 2002 version allows Track Changes on the conditioned that the workbook is switch to shared mode.

View 3 Replies View Related







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