• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problem in shared workbook

A

Abhijeet

Active Member
Hi

I have problem in shared workbook. User are 15 to 20 use same excel file then unable save that file this is problem that file lock is error message is getting. Can please give me solution for this.
 
Shared workbooks are known to be glitchy, especially as you increase the number of people accessing them. Any chance you could not use a shared workbook? Also, I see you posted this in the macros forum, so is the error appearing from a macro trying to save, or when the user tries to save?
 
Hi
Can u please tell me is their macro.From Main Data file split the data as per user Name create the new file in specific folder.then 2nd macro run then that macro can pull data from each user file & paste in to main data.
Need 2 macro 1st macro can split the data as per user names
2nd macro pull data from each user file & paste into Main Data
 
Please give me macro to split the data with user name (1 column mention the user name) & create the file in one folder the 2nd macro pull all the data from each file & paste into Main Data file
 
hi
Luke M i want criteria is user name mention in 1 column then create the file as per user names.
Then 2nd macro pull data from each file & paste in Main Data workbook.Please give me macro.I going through the link but i m not understand
 
What part did you not understand? To create the workbooks, you could use the macro in "Copy records with the same value in a column to a new sheet or workbook", and to compile, probably "Merge data from all workbooks in a folder"

Based on previous requests for macros, I'm leary of writing much code on my own w/o seeing more of your setup. There have been previous times when I provide a solution, and then the requirements change. With over 250 posts, you should have enough experience by now to read through a macro and understand the basics of what it's doing, and be comfortable with making small changes.
 
Hi Luke M
I go through this macro but my problem is not solved by this macro.Please give me Macro.I want how many user name column that data split into one folder with user name file & then copy all data from each file & paste into Main Data
 
Hi Abhihjeet,
Saying things like "but my problem is not solved by this macro" with no other information doesn't help us. If I were to write it, I would write the same thing as Ron, but I still have no idea why it's not working. When you try a solution from a formula and "it doesn't work", you should explain why it didn't work, such as:
  1. Solution provided no result
  2. Solution provided wrong result
  3. Solution caused a macro error at line ###
  4. I don't understand part _____ of solution
 
Last edited:
What format is your spreadsheet? We've just upgraded from Office 2003 to 2010, and I've come across similar problems with locking in three shared .xls files (so far).

After upgrading them to .xlsx the problems have gone away.
 
You must log in or register to reply here.
Back
Top