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
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives