ms works 9 - trying to copy values from database to spreadsheet

tbach · 08-25-2008, 01:10 PM

I was just dragged into the 21st century . . . not sure I like it at all!
Win98 was near death, so I purchased a new computer with Vista (32bit , but that's another story). I have used MSWks 3.0 for years and know my way around it.

Having a problem with MSWks 9 - have a bank deposit system set up using a database for deposits with reports created that print my deposit slips and a deposit summary. With MSWks 3.0 I was able to copy values from my deposit database to a spreadsheet that was designed to act like a mini calculator - copied list of checks from deposit and used formula to total; then copied total and pasted it back to database.

In MSWks 9, if I try to copy values from deposit DATABASE and paste to a SPREADSHEET, it arrives as a graphic instead of a numeric value . . . so my formula that forces the spreadsheet to be a mini-calculator will not work. Is there any way to defeat the "paste as graphic?" It was really a timesaver for me.

I did try to install MSWks 3.0 on Vista machine, and was successful. But ran into a lot of problems with both programs on my computer. Decided to forget about the recording function and tough it out with MSWks 9.

Thanks.
tbach

08-25-2008, 01:10 PM	#1 (permalink)
tbach Registered User Join Date: Aug 2008 Posts: 1 OS: vista (32 bit)	ms works 9 - trying to copy values from database to spreadsheet I was just dragged into the 21st century . . . not sure I like it at all! Win98 was near death, so I purchased a new computer with Vista (32bit , but that's another story). I have used MSWks 3.0 for years and know my way around it. Having a problem with MSWks 9 - have a bank deposit system set up using a database for deposits with reports created that print my deposit slips and a deposit summary. With MSWks 3.0 I was able to copy values from my deposit database to a spreadsheet that was designed to act like a mini calculator - copied list of checks from deposit and used formula to total; then copied total and pasted it back to database. In MSWks 9, if I try to copy values from deposit DATABASE and paste to a SPREADSHEET, it arrives as a graphic instead of a numeric value . . . so my formula that forces the spreadsheet to be a mini-calculator will not work. Is there any way to defeat the "paste as graphic?" It was really a timesaver for me. I did try to install MSWks 3.0 on Vista machine, and was successful. But ran into a lot of problems with both programs on my computer. Decided to forget about the recording function and tough it out with MSWks 9. Thanks. tbach