Auto Refresh The excel every 1 second

Try this.
Paste the CODE 1 in ThisWorkbook Module in VB Window.
CODE 1 :-

Please Login or Register  to view this content.

Paste CODE 2 by inserting a new Module.
CODE 2 :-

Please Login or Register  to view this content.

Save the Workbook and Then Restart it and tell if it works or not.

Its working for me..
Check the attached file:-

I have the change the following code:-

Please Login or Register  to view this content.

Check the attached file and tell if that is working for you.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Attachment 149278

Token is the file which will be used for main display.
Token shared is the shared file which is used by operators to type the token numbers.
Once the number typed in token shared file the number should instantly reflect in token file.
Token file is in display computer & token shared file is in network drive.

With Regards,
Raj.

I have been successful in doing what you are saying..

Here is the attached file:-
Token.xlsm

This the file which will be opened all computers. I mean you server and other as well.
So best if u place it in the network drive. and open it in all the computers.
The changes made on any computer will be reflected on others as well.

If It works for you then I will be telling you How I made it.

Sorry here is the attached file..

Edit:- I have corrected the attachment in the Post #12 as well.

Yes.. That what I mean..
There is no need of two workbooks. This one will do.

Is it working for you...?

Duplicate post.....

Okay..
1. Download the following file in a folder share on network.
2. Open the file. Disable Macro for the time being.
3. Click Share Workbook option in the Review Tab.
4. Check the "Allow changes by more than one user" option under Editing Tab.
5. Now switch to Advanced Tab, Check the "The Changes being saved win" option under the "Conflicting changes between users" heading.
6. Click Ok.
7. Excel will ask you to save the file. So click Ok. And a Macro warning would be shown, click OK in that as well.
8. Close the file by saving it.
9. Now try to open this file on all computers of your network. And try changing the cell value and tell if it changes on all computer or not.

While I am writing these steps, I am performing them as well. and its working fine for me.

Here is the attached file:-

Its quite unfortunate RP.
The both file were working and updating simultaneously each other when I used it on My PCs.
I have used Excel 2007 for my testing and PCs having XP installed on them.
I try to google and search what can be reasons for such in consistency.

Have a look at following links in which this inconsistency has been addressed.
http://support.microsoft.com/kb/129276

One more question, how much time does it take to save file on your PCs, as on my PCs it was quite quick.
I just want to cover the possibility that if it takes too long to save file on your PCs then it can lead to File is locked error.

Reconsider the attached file with all steps given in Post #18.
I have changed the interval from 1 second to 2 seconds.

Hi Gautam,

Good Morning. I am windows 7 on my all Pcs. The files were getting saved quickly but it were not reflecting in other PCs.
The excel file which you have used it was macro enabled file or it was a simple 2007 excel.
I tried the same with new excel but still its same problem.
Just send me the macro codes & where its suppose to be placed. With the time duration of 1 second.
I will try to create a new excel over here itself & will see whether it works or not.

With Regards,
Raj.

Here are the macros:-

Place it in the ThisWorkbook Module

Please Login or Register  to view this content.

Place it by inserting a new module:-

Please Login or Register  to view this content.

You can change seconds by changing the red bold portion. I guess, The On Error Statement can do the job here..

The file containing the code is attached. Open it. It will ask you to enable macros. Disable them. Press Alt + F11. You will find the codes there.

Yes. Exactly..
Try them will old procedure..!
I think we are very close..

Hi Gautam,

This is working but partially. Now is not showing run time error but, its still showing second error i.e the file is locked.
and its also taking some time to update it.

I THINK WE ARE VERY NEAR TO CRACK THIS THING.

Regards,

Raj.

On how many computers are running the file...?

Finally, I have made it possible.

Here are the steps you have to follow.
1. In the Shared workbook, use the following code. You have to first Unshare it and then paste the code and then reshare it with the steps I told you earlier.

Please Login or Register  to view this content.

2. Now open your Main display worksheet ( a normal worksheet not a shared one.)
3. Link the cells, which you want to update by simultaneously opening the Share Workbook.
4. After linking it, close the Shared Workbook. But keep the Main Display sheet open.
5. Now in the Opened workbook, Press Alt + F11. In the ThisWorkbook Module Paste the code below:-

Please Login or Register  to view this content.

6. Now Insert a module and Paste the code below in it.

Please Login or Register  to view this content.

8. Save the workbook as Macro Enabled one.
9. Now open it by enabling macros and Open the Shared Workbook on other PCs.
10. Update values on Shared Workbooks and See if it updates on Main Display workbook.
and One more thing, this working for me.

Note:- Linking means to Refer cells in other opened workbooks.