Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I just started using Google Docs yesterday and have discovered something quite frustrating. Anytime I go to make changes to an uploaded document, it saves the changes as a "new" document, it seems?

The document I uploaded was an Excel document. It shows with a large green "X" icon before the file name. As I work on the document, it creates a new document, but this has a little green box as its icon and says it's a "Google sheet."

Why won't it just save the changes to the original document, instead of creating a new document each time? Or do I just have to continually make changes to the "sheet" version instead of the original?

share|improve this question

1 Answer 1

Anytime I go to make changes to an uploaded document, it saves the changes as a "new" document, it seems?

Happy to take your word for that.

Why won't it just save the changes to the original document, instead of creating a new document each time?

The original document is written in a different ‘language’, though the effective difference may be little more than between English and American. Some Excel functions are just not available in Sheets (and vice versa). @Jacob Jan Tuinstra has published comprehensive lists of those that are equivalent and those that are not. However, Google makes allowances for this by converting incompatible Excel formulae to their result values on import. That’s not exactly an answer to “why” but I think is at least a part of the rationale.

With import, changes are saved to the (alternative) ‘original’ file. This can still be saved back to Excel, if required, but again there would be risk of function incompatibility.

do I just have to continually make changes to the "sheet" version instead of the original?

Not if you import the Excel document to Google Sheets (with File, Import…) rather than upload it. One advantage is that this facilitates sharing with people who do not have Excel, I'm hoping that another is that it solves your problem.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.