If you have a question about accounting, bookkeeping, QuickBooks or Peachtree I have the answer.
OK - what is the exact message you receive from QuickBooks when you go to export to Excel?
Also to try to pinpoint the problem please try the following:
(1) Run any standard report and click the Export button - then select the radio button "a comma separated values (csv) file" and try to export
(2) Follow the same steps in one except choose to export to an "existing excel report" radio button - and choose any exisiting
Excel file to export the report
Please let me know what happens when you try these two variations on exporting to Excel + the exact error message you are receiving from QuickBooks when you try to export to a new Excel file.
Exact message - "Excel could not open the data file".
1) csv file will export. File will open in Excel. It contains the data in the proper columns but is not formatted with underlines, headings, etc.
2) I exported the report to an existing file. The file wanted me to open it as a read only file. It did add the spreadsheet to the existing file. Now every time I want to open the existing file, Excel says that the file is already open but I don't have Excel open.
OK - one moment
OK - let's repair the Excel installation - what operating system is on your computer?
OK - (1) Click the Windows Start button and select Control Panel.(2) In the Control Panel, click on Programs.(3) In Programs, click on Programs and Features.(4) In Program and Features, select Microsoft Office.(5) Once Microsoft Office is selected, click Change.(6) In the Microsoft Office Installation window, select the Repair radio button, click Next, click Repair.(7) Click Finish. Your installation of Microsoft Office should now be repaired
It is asking me "Are you sure you want to remove Microsoft Professional 2007 from your machine?"
NO DO NOT REMOVE
You are looking for a Repair radio button
I see now the change button. I clicked on it and it says please wait while Setup prepares the necessary files and then the window goes away.
Make sure you select "Change"
Oh - that's not good
Do you have the CD for MS Office?
I know this will sound a little radical but I would suggest uninstalling and then reinstalling MS Office - the down side is that you will have to go to Windows Update and download any of the updates after you reinstall which takes some time but I do think the issue is with Excel and not QuickBooks especially since you can export a csv file successfully
How long do you think it will take? Is this something that I need to alot some time tomorrow to do?
I would estimate about an hour to a hour and a half - the problem with the updates is that you have to keep checking after each update to see if any more updates are available
plus you have to reboot al ot
Sounds like a tomorrow project. Do I come back to this chat to let you know how things turned out after I uninstall and reinstall?
I do have a very busy day tomorrow and will not be available till after 6pm
We can work in this char window till you are up and running with the export to Excel feature
No problem. I'll leave you a message. I uninstall through Control Panel and then insert the CDs and reinstall the software. Correct?
yes - reboot after you uninstall
then download any updates
Where do I go to get the updates?
you go to either Microsoft Updates or Windows Updates
It should be a choice when you click on Start and then prpgrams
Do these normally download automatically on a routine basis or should I be going to these sites looking for available downloads?
they normally download as they are released but since you are going to reinstall from the original CD you should go and seek them out
you can also do a google for Windows Updates
OK - we'll chat tomorrow - hopefully this will do the trick
Been busy the last 2 nights. Just now trying to uninstall and reinstall Microsoft Office 2007. Tried to uninstall through Control Panel. Got error message "Microsoft Office Professional 2007 uninstall did not complete successfully".
OK - check out this support article from Microsoft on how to manuallu uninstall MS Office - http://support.microsoft.com/kb/928218
There are a bunch of steps involved - just take your time and read through the instructions a couple of times to gain a clear understanding of what they want you to do
I will be available all day except for an errand or two I have to run - let me know what happens.
OK - let me know how it goes and if you run into any problems.
WORKS!!! It was a pain uninstalling Excel but the uninstall finally worked. Reloaded Office 2007 and now I can export Quickbooks 2011 reports to Excel.
It's not always QuickBooks but the software it interacts with
any more questions?
How much do I owe you for your time?
If you feel I did a good job you can add a bonus payment to the answer after you click accept and postive feedback is always welcome.
I'll do both!!!
Thanks - enjoy the weekend - you're off to a good start
Thank you. You too.