Unable to upload some .xls spreadsheets
Best Answer
-
I fixed the issue by doign the following:
- Opened .xls file using Excel 2013.
- Saved the file as a .xlsx (or .xlsm) file
- Closed the file
- Opened the .xlsx version of the file (I had to do this step for one sheet)
- Saved the file as .xls
At that point I was able to use the file with workbench with no issues.
I did not have the problem with all my .xls file just some. On one instance Excel did fix some error when reopening the .xlsm file. In my case it was important that I kept hte original file as a .xls as it is likned to hundreds of other spreadsheets.
I don't need any help with this issue. I am writing this in case someone else needs help with the same issue.
0
Answers
-
I fixed the issue by doign the following:
- Opened .xls file using Excel 2013.
- Saved the file as a .xlsx (or .xlsm) file
- Closed the file
- Opened the .xlsx version of the file (I had to do this step for one sheet)
- Saved the file as .xls
At that point I was able to use the file with workbench with no issues.
I did not have the problem with all my .xls file just some. On one instance Excel did fix some error when reopening the .xlsm file. In my case it was important that I kept hte original file as a .xls as it is likned to hundreds of other spreadsheets.
I don't need any help with this issue. I am writing this in case someone else needs help with the same issue.
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 468 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive