Hello thx for your answers. I know all but on my MAC computer in my excel i have Excel functions (by category) but I haven't category - User defined functions that are installed with add-ins.
After creating a pivot table in Excel 2016, you can create a pivot chart to display its summary values graphically by completing two simple steps: Click the PivotChart command button in the Tools group on the Analyze tab under the PivotTable Tools contextual tab to open the Insert Chart dialog box. Open Excel settings/preferences (Alt T O on Windows, Ctrl +, on Mac). Under 'Calculation options,' (under the 'Formulas' tab in Windows), chose 'Automatic except for data tables' and click on 'Enable iterative calculation.' Disable Autocomplete Open Excel settings/preferences. Click off 'Enable Auto-Complete for cell values.
![]()
I have all other category but I haven't user function. I installed my function correctly. I know because I can use this function by name on calculation bar but I want this function on the list by category because I installed a lot of functions and I don't know all the names. I re-install office and nothing. I do not know if this problem only affects me or all computers with OS. On my PC all its ok and work. Didn't work on my Mac.
Hello thx for you answer. All its perfect but: 1) this dialog box - insert function from Microsoft instruction (on www) its from old version excel (2011 or oldest) In 2016 excel for Mac (I have this version) insert function dialog box look like OR In first and second case I haven't category User defined function Yes I know in Microsoft instructions its SO my question its where its User Defined category in the excel 2016 for MAC Please don't send my articles from Microsoft web because I look all the articles and nothing. Maybe you have in Microsoft some Mac computer so look on your computer and check if you have the same problem as me and send my some screen with User Defined category from the Insert Function dialog box. Hi Tomasz860321, The insert function (1 st screenshot) dialog box which you mentioned applies to Excel for Windows. You should check the steps under the section Mac OS (screenshot attached in my last reply) in the article. In Excel 2016 for mac, the insert function dialog box looks like the screenshot in your reply (2 nd and 3 rd screenshot). If you want user defined function to appear in Insert dialog box, then you must make the changes in Visual Basic Editor.
Did you make these changes in VBE as described in the article? Thanks, Neha.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |