[Solved] Unable to Delete Sheet

merdontv · Post by **merdontv** » Mon May 17, 2021 12:35 pm

Hi
i can't delete a sheet.
i have read some posts and faq. but can't resolve it.
i create file example.xlsx by apache poi.
all work correctly. i closed my program and opened example.xlsx. all data into a sheet i can change. but i can't delete this sheet.
by Edit-> https://gyazo.com/ba4478d5850ec9859202edf4e9734b01 -> Delete not active
check Record(deactivated) -> https://gyazo.com/37dcafb1806c23e13b47ee4303b12182
in footer, by right click, missing any links to delete-> https://gyazo.com/456137b0bc39e6b6751ff2a90840aeda
check Protect sheet -> https://gyazo.com/ec81aa1a9ba80206fc0205773665b209
i have this picture -> https://gyazo.com/b632483a81f261f0e44af7e3dab0f860
after unchecking boxes -> https://gyazo.com/1531cdf3db07082fc197198fe04fffc0 no changes.
i changed user in AppData to Xuser by this post( Unable to Delete Sheet)- > https://bit.ly/3bwUrVp (short link by https://bitly.com/)
but it manipulation doesn't resolve my problem.
please help. Thanks in advance.

Post by **Zizi64** » Mon May 17, 2021 2:03 pm

Please upload your real spreadsheet sample file here.

edit this topic's initial post · Post by **Villeroy** » Mon May 17, 2021 4:09 pm

merdontv wrote: i create file example.xlsx by apache poi.

Then you should edit that file with MS Excel and nothing else.

merdontv · Post by **merdontv** » Mon May 17, 2021 7:22 pm

Zizi64 wrote:Please upload your real spreadsheet sample file here.

merdontv · Post by **merdontv** » Mon May 17, 2021 7:25 pm

Villeroy wrote:
merdontv wrote: i create file example.xlsx by apache poi.
Then you should edit that file with MS Excel and nothing else.

i don't have ms excel. but i need .xlsx. i need to delete the sheet but not edit.

edit this topic's initial post · Post by **Villeroy** » Mon May 17, 2021 7:38 pm

Why do you need xlsx? Excel can open (and edit) xlsx.
Of course you can not delete the one and only sheet of a spreadsheet document.

merdontv · Post by **merdontv** » Mon May 17, 2021 7:50 pm

Villeroy wrote:Why do you need xlsx? Excel can open (and edit) xlsx.
Of course you can not delete the one and only sheet of a spreadsheet document.

ok. i can't delete the one and only sheet of a spreadsheet document. Tnks

Post by **Hagar Delest** » Mon May 17, 2021 9:50 pm

OMG, it was visible in one of the screenshots.

But what is the point deleting the only sheet of a spreadsheet???

https://gyazo.com/456137b0bc39e6b6751ff2a90840aeda