I tipi di file classici non potranno più essere utilizzati a partire da gennaio 2021. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

MS excel import in Wdesk workspace

Con risposta
Richiedi una demo

Hi team,

As some formulas are not supported in Wdesk spreadsheet so when we import an excel which has used a formula not supported by Wdesk spreadsheet, it shows an error in that cell in which formula is used (like text join etc).. Is there any workaround for this other than Wdesk sync?

0

Commenti

5 commenti

Data Voti
  • Jessica Dodson

    Sync the values only instead of the formulas. There is a little check box in the lower left hand corner of the sync menu you can uncheck so that the formulas are not synched.

    -1
  • Sonali Jain

    Hi Jessica,

    Thanks for your prompt response. However, we do not see any such option when we import excel in a spreadsheet. We only see that option in Wdesk sync. Any workaround for 'IMPORT'

    0
  • Mike
    • Modificato

    Great suggestions Jessica Dodson.

    Hi Sonali! Happy to provide some insights for you here.

    If you are importing an XLSX into a Spreadsheet, it should automatically import formulas. The caveat here is that only works for those supported. Here's a listing of all supported formulas for reference: https://support.workiva.com/hc/en-us/articles/360039994631-Supported-Formulas-.\

    Sadly, I don't have  a great workaround for you here as you'll have to make changes to any cells that hold formulas that aren't supported after import. That being said, I think we can do a better job here that perhaps an error after import. I've shared your feedback and experience with our Product Team and we'll be in touch with any new development or additional questions for you

    Thanks again and hope you have an excellent day!

     
    0
  • Seng Xiong

    Hi,

    Yes, is there an option to Import values only like what we can do with the Sync function?  We like the import function but noticed that when there's formula looking at other worksheets that we are not importing or can't see, we get errors.

     

    Thank you.

     

     

    0
  • Liz Walters

    Hi Seng,

    Thank you for your question! Currently, importing an Excel file will bring in both formulas and formatting; there is no ability to exclude formulas. As you noted, Wdesk Sync does allow for the ability to choose whether or not to sync formulas. You can also can copy/paste from Excel to Wdesk to only bring in values. 

    We have created a ticket to share your feedback and experience with our product team, so they can consider the idea for future implementation. You will be updated with the status/progress of your ticket as it moves forward. Please let us know if you have any additional questions in the meantime. 

    Thank you!

    0

Accedi per aggiungere un commento.