How do I import an Excel Spreadsheet from a scanner?
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
|