Cannot save imported sheet
I wanted to incorporate a project sheet into a folder with other sheets but the permissions are such that I'm not able to move the sheet into the desired folder.
As a workaround, I exported the sheet to excel, created a new sheet in the desired folder and then imported the sheet into the new project sheet I created.
Everything looked fine in the new sheet, but I can't seem to save the new sheet, and when I close it and then reopen it, the imported data is gone.
Do sheet permissions carry through the export/import process?
Answers
-
Hi @JWood, I think I know what the problem is -- you are using the File "Import Microsoft Excel" command. This always creates a new sheet. It's probably being created in your "Sheets" folder. That's why, when you go back to the folder and look inside the file you think you added the information too, the data is missing. It was never actually "Imported" into the sheet to begin with. Your best bet may be to cut and paste the data into the final sheet, just be aware you can only cut/paste 500 lines of data at a time.
-
Thanks Lucas,
I still couldn't find the sheet created by the import process.
However I did end up cut/pasting the dating.
-John
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives