Sync my Macro enabled excel sheet online

[Techtrend]

I have a macro Enabled Excel Live sheet with formulas, the data In the excel Is RT DATA which keeps changing on real time basis, The same data has to be Synced to Google Docs or in ONE DRIVE. so that the sheet can be shared or published as an HTML PAGE LIVE

I tried installing google drive to my desktop and sharing the file, As the data is RT data it throws #NAME? error

There are 4 sheets in the excel doc and i need to sync only the 4th sheet which is named is dash board to google docs.

Can u please help me on these issues.

Thanks in advance tech team

 

[cooper]

Here I found one article on syncing Outlook with Excel and if I understand right, it works both ways. So maybe you can sync excel to outlook and then sync your sheets with Google without errors.