Paste from Excel - The figures will not paste
Issue:
I have copied the figures to my clipboard in Excel, right-clicked on the Set All box and selected Paste from Excel but nothing happens:
Solution:
Ensure that the figures in excel are NOT currency. Change to General, Number or Text.
Related Articles
How To: Paste from Excel
What is Paste from Excel? Paste from Excel allows users to copy data to their clipboard and paste into a record. You can also copy data from a record to your clipboard, to be pasted elsewhere (e.g. another record or into excel). How to use: Simply ...
One Touch Reporting: The report is showing old figures.
Question: When running my One Touch Report, it is showing old figures or dates in the reports exported. Answer: One Touch Reporting saves the exported report into your Documents folder, using the name of your forecast. If you have run the OTR report ...
Hotlink: Figures not pulling through
Issue: After adding my hotlink and selecting the row of figures, the figures are not pulling through to the record. Solution: In the Excel spreadsheet you are hotlinking to, check that the R1C1 reference style is not ticked. This is found in Files > ...
Actuals: Calculated Loan Taken is showing strange Capital Paid and Gross Payment figures.
Issue: I have entered my actuals through the enter actuals screen and the Capital Paid and Gross Payment columns on my loan records do not look correct. Cause: The loan balance and interest have been entered through the Enter Actuals screen. ...
Record List Import - Wages importing negative
Issue: When using the Record List import to bring in your data from Excel, the wages records are importing as negative values. Solution: Until a permanent solution is found, follow the steps below: 1. Enter 0 in the set all box of each wages record. ...