I am having an issue of when trying to import data into Excel from a hard
copy of a previous Excel Spreadsheet. The data imports fine, however the
formatting from the previous spreadsheet is lost and makes the imported data
hard to work with.

greenbob wrote:
I am having an issue of when trying to import data into Excel from a hard
copy of a previous Excel Spreadsheet. The data imports fine, however the
formatting from the previous spreadsheet is lost and makes the imported data
hard to work with.

---------------------

What you see is what you get. You'll note you also lost all your formulas, and
can only read in the values that were displayed. When you print hard copy you
lose a lot of information. Reading that printed file back in via a scanner
can't recreate the lost information.

The solutions a

1) Manually recreate all your formatting information, and then...

2) Keep backup files so you don't have to do it again.

Good luck...

Bill

Bill,
Thanks, that is about what I told the customer I was working with on
this issue. (she would not take no for an answer). I thought I would check it
out with people a lot smarter than I am anyway.

Thanks,
Matt

"Bill Martin" wrote:

greenbob wrote:
I am having an issue of when trying to import data into Excel from a hard
copy of a previous Excel Spreadsheet. The data imports fine, however the
formatting from the previous spreadsheet is lost and makes the imported data
hard to work with.

---------------------

What you see is what you get. You'll note you also lost all your formulas, and
can only read in the values that were displayed. When you print hard copy you
lose a lot of information. Reading that printed file back in via a scanner
can't recreate the lost information.

The solutions a

1) Manually recreate all your formatting information, and then...

2) Keep backup files so you don't have to do it again.

Good luck...

Bill