Shared workbook error
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Shared workbook error
Hi,
I created excel with userforms. I would like more than one users to use the excel sheet at the same time. I made it available in the common drive. I shared workbook in common drive. But the issue is ,
when ever i update any data in the excel using userform options in excel , its not allowing me to update and its showing error as "RUN-TIME ERROR "1004" mETHOD REFRESHALL OF OBJECT_WORKBOOK FAILED".
Does any one have clue what does it mean?
thanks
I created excel with userforms. I would like more than one users to use the excel sheet at the same time. I made it available in the common drive. I shared workbook in common drive. But the issue is ,
when ever i update any data in the excel using userform options in excel , its not allowing me to update and its showing error as "RUN-TIME ERROR "1004" mETHOD REFRESHALL OF OBJECT_WORKBOOK FAILED".
Does any one have clue what does it mean?
thanks
-
- Administrator
- Posts: 78229
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Shared workbook error
Sharing a workbook is dangerous - it greatly increases the probability that the workbook will become corrupt.
It's probably impossible for Excel to update a pivot table if several users are changing the data at the same time.
It's probably impossible for Excel to update a pivot table if several users are changing the data at the same time.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
hmmm. Thats true. Do you have any idea to do the following task?
1. In my excel i have 6 sheets.
2. I have one report sheet (sheet 3)
3. I have convert to pdf command button in that sheet.
4. I would like to see the sheet3 in PDF format 24 x 7 in one of the laptop.
4. I would like to autoopen the pdf (sheet3 only ) automatically everytime when some one edit the worksheet and update automatically.
Is it possible?
thanks
1. In my excel i have 6 sheets.
2. I have one report sheet (sheet 3)
3. I have convert to pdf command button in that sheet.
4. I would like to see the sheet3 in PDF format 24 x 7 in one of the laptop.
4. I would like to autoopen the pdf (sheet3 only ) automatically everytime when some one edit the worksheet and update automatically.
Is it possible?
thanks
-
- Administrator
- Posts: 78229
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Shared workbook error
If I understand you correctly the PDF file should be open all the time, but then it's impossible to replace it...
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
hmmm. then i think sharing the workbook will be better option :(
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
do you have any idea abt client server macro Hans?
thaniks
thaniks
-
- Administrator
- Posts: 78229
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Shared workbook error
If you want to display the results of Sheet3, you could create a separate workbook that links to Sheet3 in your workbook.
This new workbook would be updated automatically, or you could use a timer to refresh it from time to time.
This new workbook would be updated automatically, or you could use a timer to refresh it from time to time.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
thats good idea. Do you know how to do that?
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
For your information, that sheet having pivot table as well
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
Thanks Hans, its working now.
thanks a lot for your help
thanks a lot for your help
-
- Administrator
- Posts: 78229
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
lol. Its not working great mate :P
Please give me solution
Please give me solution
-
- Administrator
- Posts: 78229
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Shared workbook error
In what way isn't it great? Please provide some details.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
I linked my result sheet to another workbook.
What i done is
1. Right click on the sheet and i clicked move or copy
2. I pasted in new workbook
3. When ever i update anything in the main workbook its not updating in the new workbook.
What i done is
1. Right click on the sheet and i clicked move or copy
2. I pasted in new workbook
3. When ever i update anything in the main workbook its not updating in the new workbook.
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
for ur information, pivot table is making trouble. its not updating
-
- Administrator
- Posts: 78229
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Shared workbook error
You can put code in the new workbook similar to the code that updates your clock, but use it to update the pivot table instead.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
Thanks
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
thanks Hans. Its working. But i am getting following errors,
1. I linked one workbook to another workbook.
2. I put both the workbook in the network drive.
3. when i open both the workbook at the same system its getting updated. But when i open the source workbook in one computer and new workbook in another computer the new workbook is not getting updated.
4. The ultimate aim is i would like to put both the workbook in network drive. the new workbook will be opened all the time in one of the laptop and other workbook will be changed by different users in the network drive.
thanks
1. I linked one workbook to another workbook.
2. I put both the workbook in the network drive.
3. when i open both the workbook at the same system its getting updated. But when i open the source workbook in one computer and new workbook in another computer the new workbook is not getting updated.
4. The ultimate aim is i would like to put both the workbook in network drive. the new workbook will be opened all the time in one of the laptop and other workbook will be changed by different users in the network drive.
thanks
-
- Administrator
- Posts: 78229
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Shared workbook error
If the workbook with the link is open on another computer, the workbook with the source data will have to be saved before the changes become visible.
Perhaps an Access database would be more suitable for your purpose. Unlike Excel, Access is multi-user by design.
Perhaps an Access database would be more suitable for your purpose. Unlike Excel, Access is multi-user by design.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: Shared workbook error
hmmm. Thats good idea to create database in Access. But unfortunately i created in excel.
I have 2 linked workbooks in the same folder stored on a network accessible by a number of computers. one of the workbooks (I will refer to them as Input) are used to enter raw data, second or new workbook i consider as Dashboard workbook. When operating on the same computer all of the links function properly. The Consolidation workbook records the information as it is entered -- no muss, no fuss, no problem. Unfortunately, I don't want everything to operate from just one computer. I want each of the input workbooks to be on a separate computer, and the consolidation workbook on different computer. Unfortunately, when I try to have the Consolidation workbook operate from a second computer no updates are made as new data is entered. Is there a way to fix this problem?
Thanks in advance.
I have 2 linked workbooks in the same folder stored on a network accessible by a number of computers. one of the workbooks (I will refer to them as Input) are used to enter raw data, second or new workbook i consider as Dashboard workbook. When operating on the same computer all of the links function properly. The Consolidation workbook records the information as it is entered -- no muss, no fuss, no problem. Unfortunately, I don't want everything to operate from just one computer. I want each of the input workbooks to be on a separate computer, and the consolidation workbook on different computer. Unfortunately, when I try to have the Consolidation workbook operate from a second computer no updates are made as new data is entered. Is there a way to fix this problem?
Thanks in advance.