Forum Discussion
MS Project In MS Teams Export to MS Project Desktop
(Edited with a simpler demonstration)
It does not take much to demonstrate a situation where GEOMEAN of 2060+ data points returns #NUM.
Select A2:A2067, type 1.41, then press ctrl+Enter (not ctrl+shift+Enter) to enter 1.41 into all cells.
Note that =GEOMEAN(A2:A2066) returns 1.41. But =GEOMEAN(A2:A2067) returns #NUM.
The reason is =PRODUCT(A2:A2066) returns 1.372E+308 (rounded).
But =PRODUCT(A2:A2067) returns #NUM because 1.41*1.372E+308 would be 1.935E+308 (rounded), which exceeds the limit of 64-bit binary floating-point of less than 1.80E+308.
A work-around is:
=10^AVERAGE(LOG(A2:A2067))
If the range might have non-numeric data or empty cells:
=10^AVERAGE(IF(ISNUMBER(A2:A3000),LOG(A2:A3000)))
The latter formula must be array-entered in some versions of Excel.
-----
If that does not solve your problem, you should be able to attach an example Excel file by clicking "browse" at the bottom of the Reply window.
Alternatively, upload an example Excel file that demonstrates the problem to a file-sharing website, and post a download URL that does not require that we log in.
I like box.net/files; others like dropbox.com. You might like onedrive.live.com because it uses the same login as this forum.If you cannot post the actual URL, edit the beginning of it so that it does not look like a bona fide URL. For example, the URLfor this thread is
techcommunity dot microsoft dot com /t5/excel/geomean-producing-unexplained-num/m-p/3739059#M180397 .
PS.... But if you ``can't create a link due to organisation restrictions``, I would imagine you cannot click "browse", either. The only other option might be to email the example Excel file. But your org might restrict even those attachments. (sigh)
The project to which you are referring in Teams was created in the application known as Project for the Web. As you have found out, there is no direct way to export a P4TW project to the Microsoft Project desktop application. Microsoft's intention, I believe, is for people to export their projects from Microsoft Project to Project for the Web, but not the other way around.
I have personally experimented with a process to export a P4TW project to Microsoft Project. I first exported the project to an Excel workbook using the built-in export feature. Then I copied and pasted relevant information into an entirely NEW workbook. Then I used the Import Wizard in Microsoft Project to import the project from the new workbook. But it was a TON of work!
Hope this helps.
- Thank you!! That was helpful.
Do you know if you can access MS Project for the web outside of the Teams application addon?- Ampervor --
Navigate to the following URL in your web browser to navigate to Project for the Web outside of teams:
project.microsoft.com
Hope this helps.- If we remove access from a Teams channel where the MS Project was created can we still access using that link?
Thanks so much for all your help. It has been amazing!
