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 ...
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. ...
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 > ...
Using Reset to No Actual’s
The Reset to No Actuals feature is designed to make the next year budget easier. This works by saving your actuals as the budget figures to then allow to you extend the budget into next year using these figures as the basis for extend and amend. ...