I inserted my pivot report in odoo spreadsheet, but it is not updating automatically. And when i click data -> Refresh all data, not updating.
This question has been flagged
5
Replies
5309
Views
I found a solution to this issue.
**Root cause**: When inserting a list into a spreadsheet, Odoo hardcodes the IDs of the records present at the time of insertion into the list domain (e.g. `[('id', 'in', [1, 2])]`). This means that refreshing or re-inserting the list will always return the same records, regardless of any new ones matching your original filter. This is in my opinion a bug.
**Solution**: Manually fix the domain in the list properties.
1. Open your spreadsheet
2. Go to **Data → Spreadsheet properties** (or click on the list, then open its properties)
3. Find the **Domain** field of your list — you will see the hardcoded IDs
4. Delete that domain entirely
5. Recreate the correct filter manually
6. Save and refresh
After this, refreshing the spreadsheet will correctly return all records matching your filter, including newly created ones.
Hope this helps!
It seems like quite a few people make this mistake!
I have the same issue. Did you find any solution?
I inserted a CRM pivot table into a spreadsheet to add it to the dashboard, but some values inside the table are not refreshing. I also tried to do a manual refresh, but it didn't help. The only thing that helped was inserting a new pivot table into spreadsheets, but it doesn't make any sense when it should be automatic.
I'm curious how there is still this bug after 5 months. Does nobody use dashboards in Odoo?
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
0
Mar 26
|
2 | ||
|
2
Mar 26
|
5238 |
