Somehow, I saved an Excel spreadsheet file as a picture. Is there a way to
convert the picture into an Excel (.XLS) file or a text (.TXT) file.

When you say "spreadsheet" what do you mean?

A worksheet from an Excel workbook?

Or the entire workbook has some sort of graphics extension like .jpg or .bmp or
give us a hint?

I don't know of any way to convert a graphics file into an *.xls or *.txt file

It was suggested earlier that you use some sort of OCR application to change the
graohic to text.

Keep us posted.......I would really like to know how you saved an Excel file or
worksheet as a picture.

A range saved as a picture.....yes.


Gord Dibben MS Excel MVP


On Mon, 28 Aug 2006 15:29:02 -0700, gcotterl
wrote:

Somehow, I saved an Excel spreadsheet file as a picture. Is there a way to
convert the picture into an Excel (.XLS) file or a text (.TXT) file.

I created an Excel workbook containing 572 cells (11 columns and 52
rows).

I saved the workbook as STSNBR.XLS.

I can open the STSNBR.XLS file (which even has the Excel icon) in
Excel.

However, on the "Formula Bar", the "Name Box" says "Picture 3".
(Normally, the column-and-row location of a cell would be displayed in
the "Name Box").

A very light "border" surrounds each "cell" but, when I refer to that
"cell" in a formula -- for example, =left(a1,6) -- the destination cell
is empty.

When I hold down and drag the right mouse-button, the entire "picture"
moves.

I don't see anything in your messages that explain how you got pictures in your
file--but it sure sounds like you did it!

If you know that you don't have any pictures you want to keep:
Edit|goto|special
objects
(click ok)

Hit the delete key on the keyboard.

This will select all the objects and delete them.

If you have multiple worksheets, you may want to check the other sheets, too.

You may want to save it as a new name, too. That way, you'll still have the
original file (still with the problem, though) if you need it.

GARY wrote:

I created an Excel workbook containing 572 cells (11 columns and 52
rows).

I saved the workbook as STSNBR.XLS.

I can open the STSNBR.XLS file (which even has the Excel icon) in
Excel.

However, on the "Formula Bar", the "Name Box" says "Picture 3".
(Normally, the column-and-row location of a cell would be displayed in
the "Name Box").

A very light "border" surrounds each "cell" but, when I refer to that
"cell" in a formula -- for example, =left(a1,6) -- the destination cell
is empty.

When I hold down and drag the right mouse-button, the entire "picture"
moves.

--

Dave Peterson

You have saved a range of cells as a picture by SHIFTEditCopy Picture

The name box shows the name of the picture.

The file is still an Excel *.xls file or you couldn't have opened it.

Click on the movable picture and you should be able to EditClearAll

Your actual data may be hidden behind the picture. No guarantees though<g


Gord

On 28 Aug 2006 17:01:19 -0700, "GARY" wrote:

I created an Excel workbook containing 572 cells (11 columns and 52
rows).

I saved the workbook as STSNBR.XLS.

I can open the STSNBR.XLS file (which even has the Excel icon) in
Excel.

However, on the "Formula Bar", the "Name Box" says "Picture 3".
(Normally, the column-and-row location of a cell would be displayed in
the "Name Box").

A very light "border" surrounds each "cell" but, when I refer to that
"cell" in a formula -- for example, =left(a1,6) -- the destination cell
is empty.

When I hold down and drag the right mouse-button, the entire "picture"
moves.

I clicked on the moveable "picture" then did EDIT/CLEAR/ALL and the
picture disappeared.
However, the Excel data was not "hidden" underneath.

I then opened the original Excel file and it's an acutal Excel workbook
with columns, rows and cells.

All Excel *.xls files have columns, rows and cells.

Maybe the picture was of a range of cells on another worksheet in the same file.

Have a look at other sheets.


Gord

On 28 Aug 2006 17:35:10 -0700, "GARY" wrote:

I clicked on the moveable "picture" then did EDIT/CLEAR/ALL and the
picture disappeared.
However, the Excel data was not "hidden" underneath.

I then opened the original Excel file and it's an acutal Excel workbook
with columns, rows and cells.