I am excited to share that we have released two-way data syncing with Excel for enterprise accounts!
Your board and excel files will sync to show the most up-to-date information, no matter where you made changes!
We are excited to share this advanced functionality with you and your teams. Try it now!
The issue: Excel’s “Format as Table ” action created a 2+ million row table that borked our document sync.
If this issue is affecting you, here’s an immediate fix in Cameron’s own words:
the moral of the story is: do NOT select all the columns and click “Format as Table”. And if you do, Edit > Clear Formats and then recreate the table.
Easiest Solution (provided you want to keep using the original Excel file):
- Copy ONLY the data you want to keep into new Excel file
- In original Excel file, select Edit > Clear > Formats
- Copy and Paste ONLY data you want to keep from temporary Excel document back to original.
- Save
- Lucid: Replace Dataset
- Party because it now works!
We’ve updated our sync capability to check for overly large tables at import, which will correct this bug.
+20
+16
+8I’ve been using the “Lucid Microsoft 365 Excel Integration [Beta]” for the past few weeks. It’s AWESOME!…. well, until it stops working.
Anyone else run into a problem where two-way syncing works just fine and then just dies? I’ve even tried “Replace the Dataset”, refreshing, etc. I’ve even deleted the dataset, replaced it and still refuses to work. It loads the data, but syncing is completely borked.
Thoughts?
+8Thanks for your feedback,
+8
+8
The issue: Excel’s “Format as Table ” action created a 2+ million row table that borked our document sync.
If this issue is affecting you, here’s an immediate fix in Cameron’s own words:
the moral of the story is: do NOT select all the columns and click “Format as Table”. And if you do, Edit > Clear Formats and then recreate the table.
Easiest Solution (provided you want to keep using the original Excel file):
- Copy ONLY the data you want to keep into new Excel file
- In original Excel file, select Edit > Clear > Formats
- Copy and Paste ONLY data you want to keep from temporary Excel document back to original.
- Save
- Lucid: Replace Dataset
- Party because it now works!
We’ve updated our sync capability to check for overly large tables at import, which will correct this bug.
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to create an account.
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
