|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
PLEASE HELP! How do I export a MS Project CashFlow to an Excel Spreadsheet?
I am really struggling to export a cashflow generated in Microsoft Project as an Excel Spreadsheet.
I would like the cashflow to show the Task and the Month by Month Cashflow of a Headline cost, straight-lined over a period of 12 months. I Would really appreciate some help! Thanks, Chris |
#2
|
|||
|
|||
You don't mention what version of Project - but assuming you have Project 2007 or later, there is a Visual Report for Cash flow which creates a Pivot table in Excel.
|
#3
|
|||
|
|||
Exporting Problems
I'm using 2013, but I can't export to Excel... the program crashes... Is there any other way to get a monthly cash flow statement?
|
#4
|
|||
|
|||
The only direct method is through the Visual reports. You certainly can display cash flow in the Task Usage view copy and paste. Is Project or Excel crashing?
|
#5
|
|||
|
|||
It is the Visual Report dialogue box that freezes. I can't close it. The only way is by closing Project with Task Manager
|
#6
|
|||
|
|||
Should I reinstall MS Project? There were some issues when it was first installed
|
#7
|
|||
|
|||
Could it be I am using Project 2013 with Excel 2010?
|
#8
|
|||
|
|||
I would try a repair of Project first. (From Control panel assuming you are using Windows 7). Certainly if there were 'issues' when Project was first installed, I'd try to fix that first.
|
#9
|
|||
|
|||
Repaired
I found the fix! I went to Control Panel > Region and Language > Formats (tab) > Format Dropdown > English (United States) and then opened the report with no problem!
I then went back to Control Panel > Region and Language > Formats (tab) > Format Dropdown > and switched back to English (Canada) and then back to Project, and the report still works. Thanks for your time Julie PS: What would we do without Google! |
#10
|
|||
|
|||
Great, glad you found a work around.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Project custom field lookup from spreadsheet | bluphoto | Project | 6 | 09-13-2020 04:45 PM |
Export Data from Ms project to Ms access using VBA | virencm | Project | 4 | 02-08-2012 03:18 PM |
How do I export my contacts to an Excel spreadsheet? | Shawn76 | Outlook | 2 | 05-22-2010 07:54 AM |
Auditing on Excel and Spreadsheet documents | paulmills | Office | 0 | 12-08-2009 01:13 PM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |