Excel data transfer

[diakov2100]

Hello guys. I work with huge Excel files (over 200 mb) and I need to send to other users data that I have changed. But internet speed is quit slow, so can i send only the part of file, that i have changed (all users have the first version of file)?

Thanks for your answers and sorry for my English.

[Enderman]

Afaik excel save everything in a single file, not many small files, so no...

Unless you send data separate from excel and so that the users put it in themselves. Which would be very inconvenient.

 

Maybe if you used something online like google sheets so that the edits are just synced for all users?

[diakov2100]

4 minutes ago, Enderman said:

Afaik excel save everything in a single file, not many small files, so no...

Unless you send data separate from excel and so that the users put it in themselves. Which would be very inconvenient.

 

Maybe if you used something online like google sheets so that the edits are just synced for all users?

Unfortunatly, I can't use such services. I tried to find solution using some kind of serialization through vba, but there isn' t any thing common to languages like c# or other. So i am trying to find some built in solution

 

[Enderman]

2 minutes ago, diakov2100 said:

Unfortunatly, I can't use such services

Well unfortunately, you're out of luck.

[HarryNyquist]

What you're asking for doesn't exist.

 

From what it sounds like, you're in dire need of a better solution if you have a 200MB Excel file. Have you looked into porting this data into a database server accessible to your users?

[diakov2100]

1 hour ago, HarryNyquist said:

What you're asking for doesn't exist.

 

From what it sounds like, you're in dire need of a better solution if you have a 200MB Excel file. Have you looked into porting this data into a database server accessible to your users?

It is just a request from organization, I don't have any other resources