Sharing Worksheet

Hi, I have a spreadsheet with file name Transmittal Log which I store in shared drive or we commonly call it P:drive in our office. 1. I want to share this log sheet to all users so that every users can use and log. How? 2. I want that when other ...

Message posted on the July 2nd, 2009 - 2:36 AM ET

Sharing a worksheet/tracking payment dates

Hi, May you please assit. I need to share a worksheet with a fellow employe however I will use it for tracking of the payment dates. Also, I would like to know how do I go about setting up my worksheet i order to identify invoices that are 14days ...

Message posted on the February 15th, 2012 - 8:35 AM ET

Sharing infor between worksheets based on terms

Hello, I have a master pipeline and in the Status column there will be term such as "closed", "approved", "pending", etc. I also have additiona worksheets in the same workbook titled "closed", ...

Message posted on the January 15th, 2012 - 6:23 PM ET

Sharing script among network users

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, I have a script that does the following: 1) Opens a pre-made excel workbook (BVHigh.xls) 2) prompts the user to ...

Message posted on the January 6th, 2010 - 7:50 PM ET

Saving and Sharing with VBA

Hello, The following is a code I've made with help of several people and using the record macro function in Excel. It does everything I want it to do, BUT save and share. I've tried different things but nothing seems to work. So I need help on how ...

Message posted on the April 7th, 2010 - 2:49 PM ET

Sharing Macros

I have a macro to be released to a number of positions held not by the same person. This is to be run with a New Worksheet with data created from SAP, so therefore cannot be a Macro assigned to a Worksheet? Personal is out and "Assigned to a ...

Message posted on the February 18th, 2010 - 11:07 PM ET

Excel crashes opening Shared Worksheet

I have a shared worksheet on a file server. There are about 20 different users using it. The file is in office 2003 file format. Some users are using office 2003 some are using office 2007. When opening, some users get a crash, 3 times in a row, ...

Message posted on the October 26th, 2009 - 9:06 AM ET

worksheet change event running slow

I have a worksheet change event that has been bugging me for a while now. When I first implemented it, it worked like a charm, but it keeps getting slower and slower. And I mean to the tune of minutes, not seconds. I've waited as long as 20 minutes ...

Message posted on the July 24th, 2009 - 12:22 PM ET

copy and paste whole worksheet from one workbook to another

I need to copy an entire worksheet from one workbook to another. Currently, i am using the following code: Set objExcel = CreateObject("Excel.Application") set objWorkbook = objExcel.Workbooks.Open(Filename1) set objWorksheet = ...

Message posted on the December 23rd, 2009 - 12:36 AM ET

Locking worksheet

Is there any other way to lock worksheet apart from tool, protect? I have a workbook that I will be sharing, but apart from some cells I need it to be locked. I realized that locking it through tool, protect is about 5% safe.

Message posted on the June 4th, 2009 - 4:45 PM ET

Sharing a workbook by email

I work with a client who uses a worksheet for customer data. The client inputs data then sends the entire workbook to me by email and I add additional information (dates documents are sent to customers etc.) and send it back to them. I obviously ...

Message posted on the February 5th, 2009 - 6:18 AM ET

Sharing SQL Server connections across Sheets

We have an Excel 2007 worksheet with 44 sheets. Each sheet executes a query against a view in Sql Server 2000. The user has to enter the password 44 times, once for each sheet! She is going crazy! Is there a way for the sheets to share one ...

Message posted on the February 19th, 2010 - 11:45 AM ET

Shared worksheet will not 'share'.

I have two separate workbooks I wish to share with others on the same server. Both have all the right boxes ticked for sharing, but every time the 'other person' opens them it is 'read-only' and has to be saved under a different name if they alter ...

Message posted on the October 15th, 2009 - 5:06 PM ET

Error Message when saving a worksheet

I am using Excell 2007 and get the following message when saving a file - "Your changes could not be saved to 'file name' because of a sharing violation. Try saving to a different file." This does not happen everytime that I save the ...

Message posted on the August 21st, 2009 - 11:19 AM ET

sharing worksheet