# Joplin 1.0.218 win32 bug Excel file changes are not saved to Joplin

**URL:** <https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265>\
**Category:** Support\
**Created:** [8 June 2020 10:09 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265 "2020-06-08T10:09:16Z")\
**Posts on this page:** 19\
**Page:** 1

<div class="post-metadata">

**Author:** ![s4j4](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@s4j4](https://discourse.joplinapp.org/u/s4j4)\
**Post date:** [8 June 2020 10:09 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/1 "2020-06-08T10:09:16Z")

</div>

summary of the issue:

Windows7:  
the Excel file is not synchronized from the edited\_resources folder to the resources folder after modification and saving

Windows10:  
If other Joplin notes are opened during the editing of the attachment, the data of the edited attachment will be lost

Steps to reproduce Windows 7 failure:

1. Create an excel file and attach it to a note
2. Edit Excel file, save and exit
3. Open other notes of Joplin, and then return to the note where the EXCEL attachment is located, the data edited by EXCEL will be lost

Steps to reproduce Windows 10 failure:

1. Create an excel file and attach it to a note
2. Edit Excel files, do not save or close
3. Open other notes of Joplin (not the note where Excel is located)
4. Save and close the Excel file, and then reopen, the data is lost

Windows7 Problem screenshot：

 ![image](https://canada1.discourse-cdn.com/flex028/uploads/cozic/original/2X/f/fb551419a1b724c10d4b32986ae40f897e997706.jpeg)

Windows10 Problem screenshot：

 ![image](https://canada1.discourse-cdn.com/flex028/uploads/cozic/original/2X/a/ad50088ab860c9528f8dd63b06d3aeeb37b3a9f5.jpeg)

---

<div class="post-metadata">

**Author:** ![s4j4](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@s4j4](https://discourse.joplinapp.org/u/s4j4)\
**Post date:** [9 June 2020 06:13 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/2 "2020-06-09T06:13:58Z")

</div>

Please help, the data is lost after editing the EXCEL file, I hope you can confirm the problem. Thank you

---

<div class="post-metadata">

**Author:** ![eagle](https://avatars.discourse-cdn.com/v4/letter/e/ba8739/32.png) [@eagle](https://discourse.joplinapp.org/u/eagle)\
**Post date:** [9 June 2020 09:25 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/3 "2020-06-09T09:25:35Z")

</div>

I can not reproduce this issue. I follow every step and in #6 the edits from #3 are shown as expected.

Joplin 1.0.218 (Win10 pro) + Excel for Microsoft 365 MSO (16.0.12827.20200)

---

<div class="post-metadata">

**Author:** ![s4j4](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@s4j4](https://discourse.joplinapp.org/u/s4j4)\
**Post date:** [9 June 2020 09:40 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/4 "2020-06-09T09:40:45Z")

</div>

Thank you, can anyone who uses win7 help verify this?

---

<div class="post-metadata">

**Author:** ![laurent](https://avatars.discourse-cdn.com/v4/letter/l/ce7236/32.png) [@laurent](https://discourse.joplinapp.org/u/laurent)\
**Post date:** [9 June 2020 10:18 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/5 "2020-06-09T10:18:39Z")

</div>

It might be that Excel does something “smart” when saving the file, like not really saving it, so Joplin cannot detect any file change.

---

<div class="post-metadata">

**Author:** ![eagle](https://avatars.discourse-cdn.com/v4/letter/e/ba8739/32.png) [@eagle](https://discourse.joplinapp.org/u/eagle)\
**Post date:** [9 June 2020 10:22 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/6 "2020-06-09T10:22:33Z")

</div>

What if Joplin provided a small popup when it detects file change, saying “Your file has been saved to Joplin”?

It could also be useful when using an external text editor.

---

<div class="post-metadata">

**Author:** ![laurent](https://avatars.discourse-cdn.com/v4/letter/l/ce7236/32.png) [@laurent](https://discourse.joplinapp.org/u/laurent)\
**Post date:** [9 June 2020 10:25 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/7 "2020-06-09T10:25:33Z")

</div>

I thought about it but wanted to make the process as unobtrusive as possible - you open file, you save it and the resource is updated, no extra popup or message.

If it turns out that Office is so special that you can’t watch for file changes, we can add a warning later for these files, but by default I prefer if there’s no extra messages.

---

<div class="post-metadata">

**Author:** ![s4j4](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@s4j4](https://discourse.joplinapp.org/u/s4j4)\
**Post date:** [10 June 2020 02:56 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/8 "2020-06-10T02:56:49Z")

</div>

Hello, today I did further testing and updated the question, please help me to see. Thank you

---

<div class="post-metadata">

**Author:** ![s4j4](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@s4j4](https://discourse.joplinapp.org/u/s4j4)\
**Post date:** [10 June 2020 03:23 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/9 "2020-06-10T03:23:58Z")

</div>

Hello, I found that Windows 10 also has problems, but the probability of problems is lower than Windows7, I have updated the problem, if you can, trouble test a few times

---

<div class="post-metadata">

**Author:** ![eagle](https://avatars.discourse-cdn.com/v4/letter/e/ba8739/32.png) [@eagle](https://discourse.joplinapp.org/u/eagle)\
**Post date:** [10 June 2020 06:39 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/10 "2020-06-10T06:39:54Z")

</div>

I have tried approximately 30 times now and still can not reproduce this issue.

Every time i press Ctrl-S (or File \> Save) in Excel the file in the edited\_resources folder is updated and so is the corresponding file in the resources folder. Seems to be working bullet proof to me.

( On the other hand I wish someone would look into my [related](https://discourse.joplinapp.org/t/testing-the-new-edit-resources-functionality-in-1-0-218/9286) problem and see if they are able to reproduce that issue… )

---

<div class="post-metadata">

**Author:** ![s4j4](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@s4j4](https://discourse.joplinapp.org/u/s4j4)\
**Post date:** [10 June 2020 06:58 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/11 "2020-06-10T06:58:03Z")

</div>

Thank you very much, updated the steps to reproduce the problem in Windows 10, if you can, please take a look

---

<div class="post-metadata">

**Author:** ![eagle](https://avatars.discourse-cdn.com/v4/letter/e/ba8739/32.png) [@eagle](https://discourse.joplinapp.org/u/eagle)\
**Post date:** [10 June 2020 07:11 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/12 "2020-06-10T07:11:37Z")

</div>

Aha, with your updated steps I am able to reproduce the problem. Seems to have nothing to do with Excel as it also happens with LibreOffice and ods files.

Easily reproducible:

1. Open any attachment from a Joplin note to edit it in external application.
2. While editing the document, switch to another note in Joplin (just click on any other note in the note list)
3. Save the edited document in the external application.
4. Changes are lost in Joplin.

It does not work like that when editing _ **notes** _ in external editor - we can edit many notes at the same time with Typora for example.

---

<div class="post-metadata">

**Author:** ![s4j4](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@s4j4](https://discourse.joplinapp.org/u/s4j4)\
**Post date:** [11 June 2020 10:09 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/13 "2020-06-11T10:09:12Z")

</div>

help

---

<div class="post-metadata">

**Author:** ![RedDocMD](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/reddocmd/32/2655_2.png) [@RedDocMD](https://discourse.joplinapp.org/u/RedDocMD)\
**Post date:** [11 June 2020 10:22 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/14 "2020-06-11T10:22:58Z")

</div>

And?

---

<div class="post-metadata">

**Author:** ![laurent](https://avatars.discourse-cdn.com/v4/letter/l/ce7236/32.png) [@laurent](https://discourse.joplinapp.org/u/laurent)\
**Post date:** [11 June 2020 10:23 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/15 "2020-06-11T10:23:05Z")

</div>

> [@eagle](#):
>
> Aha, with your updated steps I am able to reproduce the problem. Seems to have nothing to do with Excel as it also happens with LibreOffice and ods files.

Thanks for looking into it @eagle. It is by design that the app stops watching when switching notes. The problem is that it's either that, or to keep on watching files for as long as Joplin is open. This is because there's no reliable way to know if a file is being edited in an external app or not.

So not sure what's the best way in terms of usability. Maybe there should after all be some banner showing "file xxxx is being watched", and that banner goes away when no longer watching?

---

<div class="post-metadata">

**Author:** ![s4j4](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@s4j4](https://discourse.joplinapp.org/u/s4j4)\
**Post date:** [11 June 2020 11:40 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/16 "2020-06-11T11:40:43Z")

</div>

@laurent  
When the file is automatically deleted from the edited\_resources folder, first synchronize to the resources folder so that no data will be lost. In addition, the files in the edited\_resources folder are not named by id, which will cause file name conflicts. It is recommended to keep the naming in resources the same.

---

<div class="post-metadata">

**Author:** ![laurent](https://avatars.discourse-cdn.com/v4/letter/l/ce7236/32.png) [@laurent](https://discourse.joplinapp.org/u/laurent)\
**Post date:** [11 June 2020 11:59 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/17 "2020-06-11T11:59:09Z")

</div>

> When the file is automatically deleted from the edited\_resources folder, first synchronize to the resources folder so that no data will be lost.

You're stating the obvious, of course the file is saved and synced before it's deleted. Read above - what you were doing is editing a file on a note that was closed.

> In addition, the files in the edited\_resources folder are not named by id, which will cause file name conflicts.

Again stating the obvious. The app of course checks for file name conflicts.

Not making any progress here, so please before posting check that what's been said before and check that what you're saying is actually true.

---

<div class="post-metadata">

**Author:** ![s4j4](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@s4j4](https://discourse.joplinapp.org/u/s4j4)\
**Post date:** [11 June 2020 12:14 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/18 "2020-06-11T12:14:40Z")

</div>

> You’re stating the obvious, of course the file is saved and synced before it’s deleted. Read above - what you were doing is editing a file on a note that was closed.

When editing files, it is very common to open other notes. In this case, data loss is a problem that needs to be solved urgently. I hope to have a more complete solution.  
@laurent

---

<div class="post-metadata">

**Author:** ![eagle](https://avatars.discourse-cdn.com/v4/letter/e/ba8739/32.png) [@eagle](https://discourse.joplinapp.org/u/eagle)\
**Post date:** [31 July 2020 11:06 UTC](https://discourse.joplinapp.org/t/joplin-1-0-218-win32-bug-excel-file-changes-are-not-saved-to-joplin/9265/19 "2020-07-31T11:06:39Z")

</div>

> [@laurent](#):
>
> Thanks for looking into it @eagle. It is by design that the app stops watching when switching notes. The problem is that it’s either that, or to keep on watching files for as long as Joplin is open. This is because there’s no reliable way to know if a file is being edited in an external app or not.
> 
> So not sure what’s the best way in terms of usability. Maybe there should after all be some banner showing “file xxxx is being watched”, and that banner goes away when no longer watching?

I think you have solved this very elegantly now, @laurent! Thanks a lot for this enhancement 🙂
