Hi Tricia, what exactly is happening when you export? Or try to export? Feel free to email me directly at [email protected] if you wish. Kind regards, Sally
Hi, I'm having the following problem exporting to Excel. The problem was present in Reckon Accounts Personal Plus 2013 and is also present in the 2015 version.
If I export a large report to an excel compatible format (about 1.5-2MB), then sometimes the report puts many lines together, i.e. newlines are missing in certain places. Sometimes when this happens, the Excel spreadsheet opens with a popup window saying that the file was not loaded completely. At other times, Excel opens normally but the bug is still present. At other times there is no problem.
This makes it difficult to compare reports from an older version of the program to a newer one when upgrading. I use a file difference program to do this and the missing newlines cause it to report differences. there are too many differences to go through them one by one.
Whether this bug occurs seems to depend on a lot of things, for example, which of two otherwise seemingly identical reports you try to export, whether another report is open at the same time, whether the report has two pages or more, or only one, whether another report was open beforehand (even if it's closed at the moment), whether you press the mouse button on the taskbar (the report takes minutes to generate and in the meantime, the screen doesn't repspond), etc. I'm not 100% sure about the last one but it seems to make a difference.
Liron did you receive a response to your problem (your request appeared to be full of "useful details").
I have just upgraded to both REckon Accounts Premier 2015 and Office 2013/365 from Office 2007. Now exporting from a Reckon Accounts report takes many minutes instead of seconds - smaller reports used to export almost instantaneously.
PS I assume this is a Reckon Accounts - compatibility issue
My multi class Reckon Accounts Profit & Loss Prior Year Comparison report has just completed after over 20 minutes of exporting to Excel 2013 (it use to take no more than a couple of minutes).
On the bright side it gave me time to research the problem on the Internet (unfortunately no obvious solution) and research ALTERNATIVES TO RECKON ACCOUNTS including Cloud based applications such as XERO.
Perhaps I'll get a quicker response than none for 10 months
I think it affects all similar Reckon Products, given that we use Reckon Premier and now this problem has added 40 minutes to our monthly reporting process.
Liron - Regarding the "Doesn't need an answer" status, it appears to be because this discussion initiated by Tricia was not set up as a "Problem".
I have now created a new Problem discussion called "Continuing Problem Exporting from Reckon Accounts to Excel 2013" and referenced it to this discussion.
I hope you don't mind, I have quoted your comment details in the new Problem discussion.
Gary Pope An Accredited Partner- Consultant (VIC. Aust) http://www.alchester.com.au/reckon-accounts-clarified/ "Working with Accountants/Bookkeepers PPs/APs, as an independent IT Professionaland retired FCPA Accountant"
Comments
Hi Tricia, what exactly is happening when you export? Or try to export? Feel free to email me directly at [email protected] if you wish. Kind regards, Sally
It would be easier for other community members to help you if you provide some more information about the problem you are experiencing.
Questions with useful details are more likely to receive a response.
-IM
How To Ask Good Questions To Get Good Answers
Hi, I'm having the following problem exporting to Excel. The problem was present in Reckon Accounts Personal Plus 2013 and is also present in the 2015 version.
If I export a large report to an excel compatible format (about 1.5-2MB), then sometimes the report puts many lines together, i.e. newlines are missing in certain places. Sometimes when this happens, the Excel spreadsheet opens with a popup window saying that the file was not loaded completely. At other times, Excel opens normally but the bug is still present. At other times there is no problem.
This makes it difficult to compare reports from an older version of the program to a newer one when upgrading. I use a file difference program to do this and the missing newlines cause it to report differences. there are too many differences to go through them one by one.
Whether this bug occurs seems to depend on a lot of things, for example, which of two otherwise seemingly identical reports you try to export, whether another report is open at the same time, whether the report has two pages or more, or only one, whether another report was open beforehand (even if it's closed at the moment), whether you press the mouse button on the taskbar (the report takes minutes to generate and in the meantime, the screen doesn't repspond), etc. I'm not 100% sure about the last one but it seems to make a difference.
EDIT: Here is some more info:
OS: Windows 8.1 Pro 64bit fully up to date
Computer specs: Intel 2nd gen Core i5, 6GB RAM, 1TB HDD
Software: Reckon Accounts Personal Plus 2013 or Reckon Accounts Personal Plus 2015 (only one or the other installed at any one time)
Excel version: Office 365 Home Premium
I have just upgraded to both REckon Accounts Premier 2015 and Office 2013/365 from Office 2007. Now exporting from a Reckon Accounts report takes many minutes instead of seconds - smaller reports used to export almost instantaneously.
PS I assume this is a Reckon Accounts - compatibility issue
My multi class Reckon Accounts Profit & Loss Prior Year Comparison report has just completed after over 20 minutes of exporting to Excel 2013 (it use to take no more than a couple of minutes).
On the bright side it gave me time to research the problem on the Internet (unfortunately no obvious solution) and research ALTERNATIVES TO RECKON ACCOUNTS including Cloud based applications such as XERO.
Perhaps I'll get a quicker response than none for 10 months
No I haven't received any replies. Please note that I had problems with Personal Plus, which is personal software, so maybe that's why.
If you look at the top of the group, it says "Doesn't need an answer". How do you go about changing that????
There is also a ME TOO button at the top. If more people click that button then maybe there will be some action.
I think it affects all similar Reckon Products, given that we use Reckon Premier and now this problem has added 40 minutes to our monthly reporting process.
I have clicked ME TOO, but not holding my breath.
Probably the best approach will be posting the issue on Reckons Facebook page
I have now created a new Problem discussion called "Continuing Problem Exporting from Reckon Accounts to Excel 2013" and referenced it to this discussion.
I hope you don't mind, I have quoted your comment details in the new Problem discussion.
See if the post at that other more recent article carrying on this topic, assists:
https://community.reckon.com/reckon/topics/continuing-problem-exporting-from-reckon-accounts-to-exce...
Gary Pope
An Accredited Partner- Consultant (VIC. Aust)
http://www.alchester.com.au/reckon-accounts-clarified/
"Working with Accountants/Bookkeepers PPs/APs, as an
independent IT Professional and retired FCPA Accountant"