They have the tools to look up your Excel setting via a secured remote access session. Feb 20 2018 Toolbars, Options, General (tab): Make sure you are not in Edit mode by hitting Esc (Escape key), as edit mode Did you install Office from Office 365 portal? https://www.youtube.com/channel/UCmV5uZQcAXUW7s4j7rM0POg?sub_confirmation=1Some Excel options are Grayed out (inactive) Fix You are wrong. Best Answers Rose-A Moderator March 19, 2019 04:15 PM Thanks for checking in with us, nicblack01. It only takes a minute to sign up. additional items that can be lost or a macro terminated and failed to reactivate something, can be found in the reset_things macro at Special characters such as an asterisk (*), colon (:), and slash (/) cannot be used in file names. Learn more about Stack Overflow the company, and our products. No other programs open. Under Cut, copy and paste, ensure the Show Paste Options button when content is pasted option is checked. That worked quickly and slick. I'm still here if anything may arise while exporting to Excel via QuickBooks Desktop. Rows to Repeat at top in File, Page Setup, Sheets: Tool Options, View, Horizontal and Vertical options. Don . PowerPivot controls disabled with non-default Excel file format This thread is locked. I've never imported data into SQL so really can't even begin to answer your question. Excel Custom VIews--menu selection is grayed out- Custom VIews--menu selection is grayed out- Discussion Options mathetes Respected Contributor May 12 2020 12:47 PM Custom VIews--menu selection is grayed out- I have a spreadsheet in which I'd like to create a Custom View , but that option is grayed out on the menu and toolbar. How to enable the 'Save and Open' option in Internet Explorer However, what is is, writing or recording a macro to create the view you need with hidden columns, or alternatively, using power query to create as many cut down views of the data as you need. Under View, select Document index. File is locked by another user and commands are grayed out If your chart buttons or Insert Form Contro. If your chart buttons or Insert Form Controls / ActiveX Controls buttons are greyed-out, this video will help you. That should do it. Labels: Macros & VBA Need Help 122K Views 0 Likes In the Excel Options dialog, select Save. Thanks. In Windows operating system, you cannot use some special characters in file names. Im ready to help if you need anything else. Can a creature that "loses indestructible until end of turn" gain indestructible later that turn? To unlock grayed-out menus for an Excel file created in a previous version, convert the file format to Excel 2007. Determine if it's a GPO getting you: If you create a local user account and then log in as that local user, does it behave as expected? Thank heavens for individual contributors like you. Find out more about the Microsoft MVP Award Program. All Excel options are greyed out - Stack Overflow How to enable the 'Save and Open' option in Internet Explorer, Improving time to first byte: Q&A with Dana Lawson of Netlify, What its like to be on the Python Steering Council (Ep. Hmmm it has been working for 2 years. The Option/Settings configuration can be performed in your Excel. I appreciate you for providing the details on how you're able to resolve your issue. Non of the macros work on her PC and all settings are greyed out. Note Using the Worksheet_SelectionChange event will clear the clipboard, which disables the Paste Special option. Find out more about the Microsoft MVP Award Program. I'm using. I have the same question (1) Report abuse Replies (4) KBA , greyed out , mb52 , list export spreadsheet , MM-IM , Inventory Management , BC-SRV-ALV , SAP List Viewer , How To . How do I get embedded Excel files to open inside Internet Explorer? will gray out a lot of menu options -- notably most Edit options (except cut & paste). I have enabled all macro settings on Excel and even uninstalled and reinstalled Office 365. Solved: Unable to export to Excel - QuickBooks Worksheets are organized into groups. Just in case any one else seeks inspiration from this discussion, the headings on the output array can be used to generate the filter criterion. Take care and enjoy the rest of the day! > even uninstalled and reinstalled Office 365. 2673 Saving an excel file Let's get you back up and running. I've recently upgraded to Internet Explorer 11 and when I try to download/open a *.csv file I get the following options in IE. This would help other users in the future. My Save button is greyed out, I have activated my account read more. same thing with any Excel file I have- network or local. 1784037 - Save Local File to Spreadsheet option is greyed out I realise this is from a long time ago and we have all moved on over the past two years. Why is AutoSave Not Working or Grayed Out in Excel? In the Excel Options dialog, select Save. 592), Stack Overflow at WeAreDevelopers World Congress in Berlin, Opening *.svg with IE9 raises 'Open, Save As' dialog. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. S SIAN 1710 Created on March 1, 2018 Office 365 options such as Save as are greyed out Hi I purchased a brand new computer at the weekend (on Windows 10) and also purchased the Home & Student 2016 version of Office . The following are the supported programs at this time: You may check out this article for more information: System requirements for QuickBooks 2018 and Enterprise Solutions 18.0. A couple of days ago, I noticed that the save icon at the top of the Excel window in version 1707 of Office 365 has been moved a little to the right because a new greyed-out AutoSave button has appeared. I don't think any of the above methods are an alternative to that. Any updates, please feel free to post back. How difficult was it to spoof the sender of a telegram in 1890-1920's in USA? If you can see the VBA Editor, please check whether there is any macro running. Installing 32 bit Office 365 worked for me too - thanks to you. Office 2019 is not yet compatible. Fortunately I ended up being able to skin this particular cat another way, thanks to all the many ways Excel offers. But oh, my, I have Tables in most of my workbooks, so I guess Custom View may become a thing of the past. I want to make sure you'll be able to export everything into Excel. Have a good one! I'm glad to know your issue got resolved. That will enlist the help of others who may have dealt with importing into SQL, Custom VIews--menu selection is grayed out-, Re: Custom VIews--menu selection is grayed out-, https://www.youtube.com/watch?v=9I9DtFOVPIg, Microsoft Excel: Advanced spreadsheet modeling using Dynamic Arrays - BRK4001. TechCommunityAPIAdmin, I have an EXCEL spreadsheet that needs to use a macro written specifically for a task. So what's the plan to fix this compatibility issue with Excel 2019?? From the File tab in Excel, select Options. (also see Backup and Toolbars), Please send your comments concerning this web page to: David McRitchie Best practices and the latest news on Microsoft FastTrack, The employee experience platform to help people thrive at work, Expand your Azure partner-to-partner network, Bringing IT Pros together through In-Person & Virtual events. Safe mode could help us troubleshoot installed COM add-ins. Cheers, GSP Excel Facts Excel Wisdom Click here to reveal answer Sort by date Sort by votes thunderfoot Board Regular Joined May 28, 2004 The setting for the default Save format is stored in the Windows Registry under the following registry data: Key: HKEY_CURRENT_USER\Software\Microsoft\Excel\15.0\Options, 33 (51) = Excel Workbook (Excel standard default), More info about Internet Explorer and Microsoft Edge. In the VBA window (Alt+F11) hit the stop button (blue square) to stop the debugger and macro recorder is re-enabled. The undo button in Excel is permanently greyed out. The "Do not save encrypted pages to disk" is unchecked. I have also run Excel and Word as Administrator yet nothing changed. However as mentioned in the next message of the same thread, i would like to organize a bigger excel sheet with few columns hidden and few filters applied to few columns, and then edit the data. How can I reinstate it? Connect and share knowledge within a single location that is structured and easy to search. If yes, welcome to post back. Excel has also given me this warning Then it's recommended to run Excel in safe mode to check these button. You can follow the question or vote as helpful, but you cannot reply to this thread. For this i understand that custom views if the only option, based on my limited knowledge. If you press Alt + F11, will the VBA Editor shown up? 2007 Excel spreadsheet won't save - Save options greyed out "Microsoft Excel cannot access the file 'C:\Program Files\Microsoft Office\root\Office16\Library\Analysis\ATPVBAEN.XLAM'. You might want to reboot your computer after doing all the troubleshooting steps that RoseMarjorie and Fritz provided earlier. If so, just delete it and re-save the file with same name or different name. In the Save Workbooks section, select Excel Workbook from the Save files in this format dropdown. I have the same question (145) Report abuse Replies (5) EL EliseM_456 Independent Advisor Replied on December 3, 2020 1784037-Save Local File to Spreadsheet option is greyed out. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. How to Unlock Grayed-Out Menus in Excel 2007 - Chron.com Save option grayed out when 'On my Mac' selected On a MacBook Pro macOS Sierra version 10.12.5, I am attempting to save a Microsoft Excel (version 15.36) spreadsheet in a csv format. I tried clean installs, updating, disabling UAC, and restarting my computer. Thank you. (I can change settings and test on my PC too for most of the options). - last edited on Step 1. I was just having the same problem after reinstalling everything on a new computer. How to solve it? send email comments, Copyright 1997 - 2006, F.David McRitchie, All Rights Reserved, http://www.mvps.org/dmcritchie/excel/excel.htm, Loss of an entire section on the toolbars (#missing), http://www.mvps.org/dmcritchie/code/proper.txt, XL97: Excel Opens Without Displaying Workbook, Google Search: excel "ignore other applications", 260199 - XL2000: Close Button Is Dimmed After Groupwise Is Installed, 828484 The Close button appears dimmed and is unavailable in Excel 2003, Excel Window, Workbook Window, Worksheet Window, Things that can prevent response, keying in data, [INDEX to my site and the off-site pages I reference], message youre getting is cannot find xxx.xls or one of its Save As and Save button greyed out, Excel 2019, Mac 09:51 AM SAP R/3 4.6C Keywords. The Room Admin is the only person who can change who has permission to bulk download. What's the DC of a Devourer's "trap essence" attack? I had four calls to QB pro advisor hotline and they convinced me QB Desktop wouldnt work with Office 365. Check the box next to AutoSave OneDrive and SharePoint Online files by default on Excel. This will help us refresh your Windows system and QuickBooks components. So you'll be assisted in forcing theAlternate Connection Method Provided for Excel 64-bit, I'd recommend contacting an IT Professional or consult with Microsoft Excel's Technical Support Team. I suppose it depends on preference, if I'm just viewing data I'd use a pivot and one or more slicers or perhaps use power query with a/some parameter/s - so I've never felt the need to use the filter function. Thank you for your response, How to Unlock Grayed out Menus in Excel (5 Effective Ways) R1C1 Reference style -- control whether you see number or letters for column headers. You can also check this article for further details about exporting data/report to Excel:Export report from QuickBooks Desktop to Microsoft Excel. Workbooks are safeguarded. Right-Click menus are grayed out (Insert, Delete, Format Cells, Pick From List, Hyperlink). New, unsaved documents will enable or disable the PowerPivot controls based on the current Save files in this format option setting. Then go to File >Options > Add-ins > Manage "Excel add-ins" > Select "Solver" from the list. Installing 32 bit version worked. Does this issue occur with other Office apps? @machetes I just noticed that you said filter can hide columns, are you sure? If you need to make changes in the file right away, you can use File > Save As to create a new copy of the file, and make your changes in your copy. We canstart by updating your QuickBooks Desktop to the latest release. gr (view in My Videos) For topics mentioned in this episode, check out the Save option is greyed out on my excel for - Apple Community Please follow this link where you'll find a similar issue! Sharing best practices for building any app with .NET. If the file is later saved as a file type that supports PowerPivot, the controls on the PowerPivot ribbon will then be enabled. it to work either. How can I - Microsoft Community Ask a new question PE PeterTownley Created on September 27, 2011 The undo button in Excel is permanently greyed out. Auto saved option is grayed out in Word, Excel, Powerpoint 2016 However the last save I had was too long ago and I added a lot since that save. Though I just ran Excel in Safe Mode and the Record Macro option is available. Same with Copy, Paste, Send To commands, but I figure what is causing one is causing all. My macros work everywhere else, only on hers is there a problem. OMG. This worked for me. Unprotect Sheet/Workbook to unlock the grayed . Single item in Insert Menu grayed out: Do you install any 3rd-party tools? Can anyone please help me figure out why my Excel options are greyed out? In the Save Workbooks section, select Excel Workbook from the Save files in this format dropdown. Have a great day ahead! A macro that hides columns and creates a view is very quick and easy to make or use/adapt these, Sub hidecols()'' will hide columns of active worksheet listed in the first range line below'Range("D:D,E:E,F:F,G:G,H:H,J:J,K:K,L:L,N:N,U:V,X:AA,AH:AJ").SelectSelection.EntireColumn.Hidden = TrueEnd Sub. Thanks for getting back to us in the Community. Anthology TV series, episodes include people forced to dance, waking up from a virtual reality and an acidic rain. My Save button is greyed out, I have activated my account My Save button on Excel, Word, etc. Symptom. It will be of help to me, as i too have the same issue. Fix export to Excel issues in QuickBooks Desktop No, it won't affect whether you can export or not. 8 satisfied customers. Thanks for the feedback, Nic. components. Is there a setting I can change to allow me to save and open these files? What should I do after I found a coding mistake in my masters thesis? I am experiencing the same issue with a client who is using Office 365. We'll be right here if you have other concerns. Fix: Save Button Grayed Out In Microsoft Office Word, Excel, & PowerPoint This way, the program will recognize that you have installedMicrosoftOffice 365. CommandBars("AutoCalculate").Reset See what options are available under Tools, Protection (#quickcheck) The user can open and work in any Excel file. That said with macro's you can create views based on hiding columns and selecting/hiding certain rows. We tried reinstalling MS Office. Please let me know how it goes or if you have any additional questions. Also is this your personal computer where you control all settings, or is this a company/work computer? Any change to one sheet impacts all grouped sheets (deleting rows, entering values, etc) To UNgroup the sheets: Click the tab of any sheet that is not part of the group or Right-Click one of the grouped sheet tabs.Select: Ungroup Its good youve performed some troubleshooting steps to resolve the issue. When you go into File>Save As>Tools>General. If you have extra questions about this answer, please click "Comment". The Auto Saved Option is grayed out on all the Microsoft tools like excel, word, powerpoint, version 2016. First, for the sake of clarity, I'm talking about the FILTER function, only available in the newest versions of Excel. On the other hand, you can also get in touch with an IT Professional for further assistance with the steps. Some Excel options are Grayed out (inactive) Fix - YouTube I am checking this thread, do you have any updates? But the issue re-appeared. Why does ksh93 not support %T format specifier of its built-in printf in AIX? Is it now impossible to run macros even in .xlsm files? Could ChatGPT etcetera undermine community by making statements less significant for us? @mathetesyou can't hide columns with filter though. So here's a short list of some of the things that I might have had in mind at the time. To learn more about what minimum requirements are to run in QuickBooks Desktop, you can read this article: System requirements for QuickBooks 2019 and Enterprise Solutions 19.0. Go to the Actions menu, select Bulk download. Custom VIews--menu selection is grayed out- - Microsoft Community Hub Browse other questions tagged, Start here for a quick overview of the site, Detailed answers to any questions you might have, Discuss the workings and policies of this site. http://www.mvps.org/dmcritchie/code/proper.txt, Also along these lines do not ship your toolsbars file to someone else Today, Katelynne shares some Once done, you can try exporting anything in your QuickBooks again. When I select the 'On my Mac' option, save is grayed out: If I switch to 'Online locations' the option to save is available: It is a basic install of MS Excel with default settings. We have since spoken to Microsoft and they downloaded 365 personal. What are some compounds that do fluorescence but not phosphorescence, phosphorescence but not fluorescence, and do both. > Though I just ran Excel in Safe Mode and the Record Macro option is available. I am running the program on Mac OS Catalina 10.15.5 on a MacBook Pro (Retina, 15', Mid 2015) I am an absolute noob when it comes to Excel so I would be very very grateful if someone could help me! If you have Microsoft Excel installed on your computer but you can't export reports and other forms from QuickBooks, don't worry. Here's how: Thanks for your patience while were continually on this. Our active member (EagleFox) is referring to this tab (Advanced tab): You can see attached screenshots for additional reference. To create views with particular rows visible or hidden there's now a built in feature called sheetview on the view menu. I suggest reaching out to our Customer Support Agents so they can your account to the investigation. submenus, but the submenus are found to be also grayed out. Those options are greyed out . Allow me to guide you and help ensure you'll be able to export your data to Excel successfully. 10 Answers Sorted by: 3 It probably means that you have grouped two or more sheets .Be very careful. The 7 reasons why buttons might be greyed out are:1) You are editing a cell2) Your worksheet is protected3) Your workbook is protected4) Your worksheets are grouped5) Objects are hidden (advanced display option)6) You are sharing your workbook7) You have tracked changes turned on------------------------All enrolments and purchases help this channel (a commission is received at no extra cost to you):5 FREE Excel Templateshttps://www.simplesheets.co/a/2147506566/v7Aj9zMxEnrol in the Excel University FREE taster course availablehttps://www.simplesheets.co/a/2147491676/v7Aj9zMxGet 30% Discount on Simple Sheets Templates and Courses https://www.bluepecantraining.com/simple-sheets-templates/Use Discount Code BLUE By clicking "Continue", you will leave the community and be taken to that site instead. Kindly assist Show moreLess Posted on Oct 12, 2021 11:36 AM Reply Me tooMe too Similar questions Excel file cannot saveExcel file on macbook. Probably the most useful thing that custom views did, which no other out of the box feature seems to do, is present a view of a very wide (many columns) table with some or many columns selectively hidden. Out of desperation I actually bought a stand-alone Office 2016 licence with no luck. I can open Excel spreadsheets but cannot save them or print. Thanks. Would 32 bit VS 64 bit versions of Excel have any effect on whether I can export or not? Thanks. Best practices and the latest news on Microsoft FastTrack, The employee experience platform to help people thrive at work, Expand your Azure partner-to-partner network, Bringing IT Pros together through In-Person & Virtual events. Try to enable AutoSave feature in Office, Excel, Word. You'll then need to reconcile your changes with those made by others in their copies. I was trying to record while the "debugger" was running - and recording macro was greyed-out/disabled. Let's get you back up and running. Copy (Ctrl+C) of locked cells on a protected sheet results in Click the "Office" button and choose "Convert" to change the file to the Excel . 08:34 AM Microsoft EXCEL 2016 MSO (16.0.9001.2080) 32-bit. In Microsoft Excel, when attempting to use controls on the PowerPivot ribbon, you find that the controls are grayed out, as in the following figure. Password-protected spreadsheet. We just upgraded to QB 2019 Premier, Manufacturing module. Connect with and learn from others in the QuickBooks Community. I agee with your comment - QB needs to update its responses online, train the phone tech support but also explain why 64 bit stopped working. Get us a fix, PLEASE!! Additional keywords: grayed out, greyed out, unavailable options AutoSum is grayed out (#autosum) If the sum option has been programatically disabled, you can reset it by running a macro with this line of code: Jim Rech 2002-05-30. It's giving some out of memory error. VBA and Record Macro Greyed out on Excel - Microsoft Q&A @mathetesI see. Unchecked the boxes in the Advanced tab for Excel options and then exported. Or did you run ODT with configuration file (.xml)? Any advice would be greatly appreciated! copying Values instead of formulas. QuickBooks is capable of integrating Office 2010 and Office 2013/365 (including Outlook 2010 and2013) both on 32 and 64 bit. Computer or User Configuration-> Policies-> Administrative Templates-> Windows Components -> Internet Explorer -> Compatibility View. Does anyone know how to turn it on? I'm sorry to say that I don't even remember what workbook I was working on back in October when I posted that (my first question on this site). since then I've discovered so many other new (new to me, that is) features in Excel that I've not even missed Custom View. 1 I want to be able to save my excel sheets, but the save button is greyed out and I don't know what to do. You can follow the question or vote as helpful, but you cannot reply to this thread.