Convert to range - from Table

[Vishal.jagani]

Hey Guys,

I have little issue, I am running Powerquery everyday in my excel file
after run PQ I need to convert data from table to Range

So I am doing everyday this process through

Process: Right click anywhere into file -> Table -> Convert to Range

But suddenly today that option is disabled I don't know why but that's true

What is possibility for that particular reason - I can't convert into range

Do needful If anybody knows

Vishal

 

[Luke M]

Strange. Did the sheet get protected somehow? If you go to the Table Tools - Design ribbon, is the Convert to Range button there visibe?

 

[Vishal.jagani]

Hey Luke That option also disabled ;(

I have checked that also

find screenshot

 

[Luke M]

any change you can share the file?

Only other though would be to save a copy of the file, then start forcibly deleting rows/columns and see if the option comes back. Maybe there's some hidden width/height limit??

 

[Vishal.jagani]

I really don't know what to do ?