Re: "out of memory" message appears when I try to print a...
Obviously, your PC is quite an older one with less than the required memory. You might also have run other programs that might be hindering your MS works 8.0 as these programs are memory intensive! Solution: Add more than 2 Gig bytes of new RAM ( shop around for a cheap/reliable one )to your PC system as the required memory! As for the page file ( find it under 'Control Panel - System/ System Settings - Advanced - Performance Options - Advanced - Virtual Memory - C: or D: or whichever your logical drives you might have' ), try to increase it to 2 Gig bytes!
A security factor worth taking note of: Use drive D: or whichever data drive your PC uses for its data as sometimes hackers try to hack into your System/ OS drive like C: so as to compromise the IT security.
Your MS works 8.0 might require a re-installation after the increase of the RAM and the page file!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*OpenMS Excel >pressCtrl+O >locate corrupt excel spreadsheet and select it.
*Click on the arrow shown besideOpenbutton>selectOpen and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.
Or if this doesn't work, one may take help of a third-party
Hi,You may have a phisical problem in your qp file.One trick is to open a new file in X4 and with the cursor in the first cell go to Insert on the tool bar, File, and insert the old file. Try, too, with older versions of the file, may be some new info added is not working. Good luck!
Type "excel password recovery" into Google and you'll have a choice of many suppliers who sell software that will reveal an Excel password. I have tested most of their free trial version .Excel password recovery 5.0 is my favourite one,it is 100% recovery rate and easy to use.and most of all,it is the cheapest.just have a try
You would need to increase your virtual memory and restart your computer. Windows XP:
Right click my computer, go to properties
Select the advanced tab
Click advanced tab
Click change under virtual memory.
Set virtual memory 1500 to 4000
click set and apply, ok
If the memory is set higher, select a higher number.
This should resolve your issue.
If Sale Line 100 is an Excel Template then it is simple.
The Templates are just preformatted spreadsheets which are edited just like any other spreadsheet.
If you mean that you are using the Template to create another document but wanting all the fields to be the same as the Invoice then I suggest the following method:
Copy the Template fron Worksheet 1 onto Worksheet 2.
Add and remove any fields that you wnt to add or remove (Prices would be deleted on this copy and the title would be changed from Invoice to Delivery Docket, etc)
Then (on Worksheet 2) in the fields that you want to be the same - click on the cell you want the same Data in and hit the = sign. Then go to Worksheet 1 and Click on the cell that you want the data to be the same. Hit Enter. This will send you back to Worksheet 2 and you will see that any data entered into the cell in Worksheet 1 will now also appear in Worksheet 2.
Repeat this process for all the cells you want copied from worksheet 1.
When you complete the data in Worksheet 1 (the Invoice) all the data selected will automatically appear in the cells selected on Worksheet 2.
Try this on worksheet 2 select cell A1, type =, then open worksheet 1 and select B1. You will be returned to worksheet 2 and the formula in cell A1 will now read =Sheet1!A1. Enter anything into Shhet 1 A1 and you will see that it appears in the appropriate cell on Sheet 2.
When you want to print off the Invoice and the Delivery Docket - you only have to open each Worksheet and hit Print and a copy of each worksheet will be printed giving you an Invoice and a Delivery Docket with the appropriate info on each printout (eg if you exclude prices from the Del. Docket then after completing all the details in the Invoice will create a Del Docket with all the relevant information other than the prices.