Appactivate Excel Not Working

it does not copy the formula it copies the number 10 So in effect, it is doing a Copy / Paste / Values? Try running a Diagnostic: Running Microsoft Office Diagnostics from within Excel/Word. Open Excel Workbook > File > Options >Advanced. By Greg Harvey. But it's wierd: sometimes SendKeys works like I programmed them, sometimes just some of the SendKeys commands work, sometimes Excel "calls" the SendKeys in a different order than from what I've programmed, and sometimes SendKeys doesn't work at all. Working with units in Excel – using VBA and Python Posted on July 15, 2018 by dougaj4 One of the most frequent reasons given for not using Excel for engineering and scientific applications is its very limited facilities for dealing with calculations involving units. Excel how to filter properly. For example, if the computer becomes infected by a virus, then the clipboard stops working (CTRL+C or CTRL+V are not working and "Paste" command is greyed out). Problem is, the open window keeps popping up in the last folder I was in, instead of the one I'm trying to direct it to with ChDir. External links for other issues that might prevent filter function to work properly. ----- Its not working when i try to use it between 2 Workbooks. After open the. Excel formulas not working, not updating, not calculating: fixes & solutions by Svetlana Cheusheva | updated on January 9, 2018 199 Comments This tutorial explains the most common mistakes when making formulas in Excel, and how to fix a formula that is not calculating or not updating automatically. It comes as part of Microsoft Office 2010 , which also includes other leading apps such as Microsoft Word and PowerPoint. I was trying a few times to put some applications to check out and nothing worked. No worry! Here is the best solution to solve Adobe Excel to PDF not working problems. r/excel: Discuss and answer questions about Microsoft Office Excel VBA code works in Windows 7 but not in Windows 10. With a current point score over 100,000, they've contributed more than 3000 answers in the Microsoft Support forums and have created almost 200 new help articles in the Technet Wiki. One example is when you accidentally trigger the scroll lock feature. An Office 365 subscription offers an ad-free interface, custom domains, enhanced security options, the full desktop version of Office, and 1 TB of cloud storage. WRONG ANSWER (I could not delete my answer completely without writing something else. It comes as part of Microsoft Office 2010 , which also includes other leading apps such as Microsoft Word and PowerPoint. org/up-down-arrow-keys-are-no. No, it should work the same way (see below). To do this, select the work items you want (hold Shift to select multiple consecutive work items or Ctrl to select multiple work items) and use the Right-click on selected work items to "Open in. In my macro, I need to use the SendKeys command for various reasons. Weekends are not considered work days and you can specify holidays to also exclude from the work day calculation. I also updated the app activate command to: AppActivate Title:=ThisWorkbook. There are a couple of things that must be in effect in order for Alt+Enter to work properly. This is not the only problem. In the Editing Options section, clear the check box entitled Zoom on Roll with Intellimouse. The custom function must include this interface both as an input and output argument. After creating the shortcut, if you press Ctrl + Shift + C, a blank comment is inserted in the cell, but the comment does not open for editing -- the SendKeys method doesn't work. Microsoft Excel 2013, free and safe download. letters all work. Apr 15, 2016 · Once the files have been closed the fan slows back down to a normal rate. PI Datalink COM add-in not working. Office 2013 Service Pack 1, Excel 2013; In this article Symptoms. This is not a good practice and it's not recommended or supported, so let's forget about this one. Developers from all over the world come together to share knowledge, source code, and tutorials for free to help their fellow programmers - Professional Developers, Hobbyists and Students alike. Re: AppActivate stopped working There are a few things that may be effecting this, first, check to make sure that Microsoft Word is still the wording on the bar at the top of the application. Curiously, if you're doing simple arithmetic with cells that contain numbers stored as text, Excel will perform the calculation without issue. is some parameter in function module should be passed for this??. If anyone have fix, please let me know. Windows Internet Explorer (8-9) do not conflict with the Excel 2010 Paste Special option. In cell D6 of sheet1 of Book2. It would probably be better to give an example. Analyze in Excel not working after updating Office 365 to latest update (Version 1709) Submitted by NaqashBI on ‎10-30-2017 12:22 AM Users starting reporting that their Analyze in Excel feature is not working anymore in Power BI. Proficiency in Microsoft Excel is highly sought after in a multitude of careers, not to mention it's a great tool to keep track of personal finances. Post Cancel. xlsx, rewrite the VLOOKUP() function. Go to the first line and add above that line a new line with sep=, (with a comma, not with a semicolon). In cell D6 of sheet1 of Book2. Excel not filtering the entire. If you're not finding what you're looking for, it's in your find parameters. You can use AppActivate only with processes that own windows. I've gone through the Trust Cente an enabled macros and clicked trust access to VBA. In other words, you cannot just select a cell and press Alt+Enter. The label is a passive control meaning that the user never really acts on it. I am working with an Excel spreadsheet and saving it as a. With Excel, files can only be accessed within a close network and it is limited to certain PCs. Formulas are the key to getting things done in Excel. ScreenUpdating-Property does not work properly in Excel 2016 / Win 10. For details : http://tectrick. Re: Find (Ctrl + F) and Replace Not Working I have found that sometimes, you must search in the format of the cell. , which makes it really easy to format the individual data series. My problem is that the AppActivate and SendKeys combination only seems to work intermittently. After creating the shortcut, if you press Ctrl + Shift + C, a blank comment is inserted in the cell, but the comment does not open for editing -- the SendKeys method doesn't work. When one person is in a speadsheet and another person opens it it does not always prompt as ready only. Save the file and open it with Excel 4. Does AppActivate not work with Windows Explorer? > > > > > > Thanks Last edited by Daniel Duta; It's not a bug--it's a feature. An example can be seen here:. The connector assumes the first row as the column headers. Troubleshooting for "Excel Hyperlinks not working" doesn't involve much time but there is a possibility that what you get is not as expected, meaning the hyperlinks are not repaired. The situation is simple. For example, you might have the boring task of copying certain data from one spreadsheet and pasting it into another one. Any reference to a range is fully qualified. Enter the number 1 into a cell and copy it. Paste the following code into a new code module, and run the macro ActivateExcel. Microsoft Excel provides 4 logical functions to work with the logical values. Try going into "Programs and Features" in Window's Control Panel. xlsread does not change the data stored in the spreadsheet. Sub DL(URL as string) Shell ("C:\Program Files (x86)\Google\Chrome\Application\chrome. It’s worth mentioning that this problem also affects other third-party application. Holidays - an optional list of holidays that should not to be counted as work days. We're assuming that you're at least slightly familiar with MS Excel. We have not been able to get coauthoring to work inside of Excel 2016, even with the current updates. Alt Tab not working with Excel – Sometimes this issue can affect other applications such as Microsoft Excel. NET MVC 3 based reporting application. > what appears In the Excel Title Bar. When I try to refresh the data i'm not able to click the refresh button. " most of the time it will not work use appactivate function Comment. To do this, select the work items you want (hold Shift to select multiple consecutive work items or Ctrl to select multiple work items) and use the Right-click on selected work items to "Open in. I am writing the data in excel using APIs provided in this code. If you are seeing problems in other scenarios, it would be helpful to provide a more detailed description of what you’re seeing and the steps that lead up to the issue. It's Grey tinted. csv data as transactions. VBA excel code does not work in Excel 2016 I have an excel file (. This page collets the comprehensive 8 solutions to fix Excel not responding. I am at a loss for why it works for me on one laptop but not another. I am having an issue where I am unable to utilize Paste Special in Excel 2016. and that didn't work either. Activate method in a Microsoft Excel 2013 workbook, the workbook is not activated if the ScreenUpdating property is set to False. With text files, you can place them all in one folder to form a database. I have an Office. 4738) complained, that the slicers and pivot-filters do not work. I'd rather not post the workbook because it contains a lot company confidential information so shouldn't be made public. appactivate command doesn't work. Open the CSV file via a simple text edit / note pad editor. read_excel() with name keyworkd does not work anymore. Update - after doing my homework to get excel to work for me via Microsoft account I now realise that it will never work for me on a subscription free basis as I have upgraded to an iPad Pro which is 10. IT Help > Software > Hyperlinks are not working in Word, Excel and PowerPoint documents Hyperlinks are not working in Word, Excel and PowerPoint documents Article: KB0011154 Published: 29-04-2015 Last modified: 18-03-2019. This Excel tutorial explains how to use the Excel NOT function with syntax and examples. pptx" AppActivate "test. It’s worth mentioning that this problem also affects other third-party application. AppActivate doesn't always work Showing 1-12 of 12 messages. However, the slicer connection is only showing 1 pivot table. Formulas are the key to getting things done in Excel. The Find function finds only what you actually entered. I am using FM ""Reuse_Alv_grid_display'. Sometimes you may want to select a specific set of work items from a query, not the entire query. If your column headings are merged, when you filter you may not be able to select items from one of the merged columns. Suddenly the wheel worked in both Excel and IE. Re: Find (Ctrl + F) and Replace Not Working I have found that sometimes, you must search in the format of the cell. On November 11, and since then, my printer will not print Excel docs, Word docs, nor my emails off my email server. The application title passed to AppActivate isn't necessarily the name of the program file of the application; it's the name currently displayed in the application's titlebar. My solution, eventually was to NOT use AppActivate at all, in fact opening the document brings it to the forefront anyway. REST API in Excel Services does not work when a SharePoint web application using Claims-based Authentication is protected with CA SiteMinder®. AppActivate. Taking a tip from Maciek, I clicked down on the wheel within an Excel cell to get the navigation arrows to appear, moved the screen a little and clicked the arrows off. For example, when I input =COUNTIFS(range, ">1", range, "<=3" I am also not getting the expected value. We need to use start to open excel application from command line. I am trying to export responses from a specific form to Excel and get a message that it is "converting" and then nothing happens. The Shell procedure assumes the applications are in the paths specified. When working with a report exported from Practice CS to Microsoft Excel, you may experience unexpected results while sorting and filtering data. If it doesn't uninstall and reinstall Microsoft Excel or Office as a whole. This is messed up, but my scroll wheel was not working for either Excel NOR IE. When you try to print an entire excel workbook, you may find that each sheet is being saved as a different file. For example, you might have the boring task of copying certain data from one spreadsheet and pasting it into another one. Selecting a cell with Mouse doesn't always work. As this article is intended for the beginner/intermediate level, a quick demonstration of read/write operations on Excel files is supplied with the help of a sample WinForms application. Office 2013 Service Pack 1, Excel 2013; In this article Symptoms. Also make sure what you have is really is an Excel file and not some other type of file that has been saved with the. I downgraded from Acrobat DC to Acrobat XI and now have the issue that links are not included in my PDF. Export to Excel is a useful SharePoint feature. My CSV was comma separated. and I'm not able to use the datepicker control. 00" in one or more cells will not be found if you actually entered only "19" in the cell, set the cell to display "19. now nothing. Hi, yokeloonlo First try the Hui's idea, if it not work, then try this, i think the Cell which you are going to enter the formula may be in Text format, if that so, any number or formula you entered will remain the same, excel will treat it as text value. Advantages of this approach allow: to use native Excel functionality like filtering, coloring cells, changing format, etc. I've imported 9 csv files from a folder location, promoted the headers and then filtered the rows to remove the headers of the other 8 files. Formulas are the key to getting things done in Excel. Because your global template file has your settings, I would rename the file to something like normalPRV. We use MS Excel 2003 on XP. If you have a VBA Editor open, the system will set focus to that Editor window, rather than to Excel. I'm using Excel 2010 (32-bit) running on windows 10 (64-bit) Would you please help me on that?. 19ghz processor. AppActivate("Untitled - Notepad") ' AppActivate can also use the return value of the Shell function. The only table that has unique values is the Vendor_Key table. I am trying to export responses from a specific form to Excel and get a message that it is "converting" and then nothing happens. I get the message that the AppActivate does not work :(. Re: proper use of AppActivate Hi cytop, We have at work a oracle application that is wraped in java (I think) and wanted to automate a little bit the copy paste from excel to the application. When one person is in a speadsheet and another person opens it it does not always prompt as ready only. When you try to print an entire excel workbook, you may find that each sheet is being saved as a different file. xlsx" End Sub. Oct 25, 2017 · This has been working fine, however it doesn't work in Excel 2010. When this issue occurs, it becomes difficult to enter data in the Excel cells and worksheets. This article simplifies your work with MS Excel (both xls and xlsx) using Oledb and Microsoft Data Access. Manage spreadsheets, tables and workbooks attached to email messages from your phone with this powerful productivity app from Microsoft. Use Center Across Selection in the format, cells, alignment and make sure Merged cells is not on. Calling AppActivate does not help. If the formula is on a table when you click on the cell a new tab called "Table Design" at the top of your ribbon should appear. The Microsoft Excel NOT function returns the reversed logical value. This means you can delete the sheet that contains the source data and the pivot table will still work. 2 is a 64-bit release, while SAS 9. One example is when you accidentally trigger the scroll lock feature. On other computers it works just fine, so I think I have a wrong setting on my laptop. Work smarter, not harder. any advice how can I fix this problem Thanks AlerT. Scrolling works everywhere but Excel (part of Office 2010 Professional Plus. The situation is simple. For instance, the formula =ISBLANK(C2) will return TRUE if cell C2 is blank or FALSE if it isn't. The following works starting in Excel and opening iexplorer. The AutoComplete feature does not automatically suggest "aBC" in cell B2 as it does in step 3. xlsm) with extensive calculations running through VBA coding. Meanwhile, I came across with a lot of stuffs, and. Something More to Check: File, Save As, Tools, General Options, Read-Only option is on the same dialog that you use to set a password. Excel VLOOKUP not working - solutions for N/A, NAME and VALUE errors by Svetlana Cheusheva | updated on March 26, 2018 134 Comments The tutorial explains how you can quickly cope with VLOOKUP not working problems in Excel 2016, 2013, 2010, 2007 and 2003, troubleshoot and fix common errors and overcome VLOOKUP's limitations. When the same document is opened through the Home Network on a different PC (also using Word 2016), both "Edit Data" and "Edit in Excel" work just fine, and a window pops up for editing the data. I'm not sure how I can make your proposed solution work since the VBA app I'm working on is hosted within PowerPoint. > what appears In the Excel Title Bar. Displaying The Current Workbook palette. Review and edit documents from anywhere with the Office mobile apps. Suddenly the wheel worked in both Excel and IE. If it doesn't uninstall and reinstall Microsoft Excel or Office as a whole. Actually, there are two different phrases with the same beginning “DataNumen ” (with the space) in Cell A1 and A2. Re: AppActivate and SendKeys I'm sorry, my understanding/aptitude is relatively low. He wonders how he can load this tool into Excel 2010 and Excel 2013. If that's the case, you can easily solve the problem whilst using Excel office. That is where we are now, how do I get all my old excel, matlab and vba projects into python? The first step is to install python. Then, if you want to print just the table, without the other items on the worksheet, you can use a built-in command -- Print List. I have updated Windows and all Office apps to the latest version but that hasn't fixed the problem. Select the column formatted as text, press Shift+F10 or right-click, and then select Paste Special from the shortcut menu. Re: Excel copy / paste function does not work with Smartview Rush Oct 28, 2013 3:06 PM ( in response to 908911 ) In Office 2010 (Excel) we found that we sometimes we have to also select all tabs and copy them to a new workbook. The Microsoft Excel NOT function returns the reversed logical value. I downgraded from Acrobat DC to Acrobat XI and now have the issue that links are not included in my PDF. First, open an excel working book. First, assign your workbook to an object variable, and then refer to that variable when you want to activate that workbook. in a newly created workbook (created with the newly upgraded Excel 2013) then it works without a hitch. ‘Open and Repair’ doesn’t work: Try alternative solution i. When you select a range of cells in Excel 2013, a small icon appears in the bottom right corner. There are a couple obvious options to fix this, but none was working. I have downloaded the excel automation code from codeproject and used this code in my MFC application. It’s amazing to me that MS would remove this functionality from Excel in the first place. Re: AppActivate "Microsoft Excel" is not working The AppActivate statement requires the title of the title window. Knowing Excel and by that you say you use the workbook for a while now, the source of the issue is possibly that the file is full of garbage (Excel is not really good in cleaning up reverted actions or removing cell-reference if you delete data from it with the DEL key). It can be used as a worksheet function (WS) in Excel. The NOT function reverses the value of its argument. 4738) complained, that the slicers and pivot-filters do not work. External links for other issues that might prevent filter function to work properly. And then go into Tableau to refresh the data source pointing to that Excel file. excel 2013 macros not working Jan 08, 2014 · Thats not really a solution, is completely pointless. Alt+Enter Stopped Working Correctly. In fact, the add-in file will not open in Excel at all,. aspx) to render the workbook by examining the URL:. I haven't noticed that because I'm not using excel very often, but it seemed to be faster than writing a script for that task. XLS extension to trick your operating system into using Excel to open the file and letting Excel convert it on the fly. Save documents, spreadsheets, and presentations online, in OneDrive. We need to use start to open excel application from command line. You can use AppActivate only with processes that own windows. Foxit Word to PDF Converter refers to a PDF creation tool that converts any document to the universally accepted PDF format with just a click of a button. Nor the brand cydia tweak updates are vba appactivate not working ATA Device for Internal Hard Drive. Click the Microsoft Office button Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window). Everywhere else it was working. The Shell procedure assumes the applications are in the paths specified. To make a chart in Excel, you need to write the data into a worksheet and then build a chart that uses the data as a data source. See if that fixes the issue. "Excel is not responding" "Excel has stops working" So you are probably wondering: How to fix Excel not responding? We are helping you. I have an extended keyboard on a MacBook pro and the number pad won't work. Sometimes, there may be issues seeing the Excel Add-in. VBA excel code does not work in Excel 2016 I have an excel file (. Plotting with Microsoft Excel 1 Plotting Data with Microsoft Excel Here is an example of an attempt to plot parametric data in a scientifically meaningful way, using Microsoft Excel. PI Datalink COM add-in not working. "filename" is the word "filename" (in quotes) - don't replace it with your workbook file's name. I do not get any errors, it just does not work. So have you ever had your F2 editing button stop working? (I use mine a lot for editing cells in Excel). I did some research, most of which states that people do not like using the AppActivate function. Read range does not work when Excel sheet is protected. Why does EXCEL not work properly with Windows Alt+TAB application switching, for some reason you have to press ALT + TAB and then hold down ALT and press TAB a second time to able to switch to the. I missed this one when Matt asked the same question and Thanks very Novice? Spend a few minutes browsing Appactivate Microsoft Powerpoint. a wireless Targus keypad suddenly doesn't work anymore either. Surface Pro 6. Free VBA Tutorial If you are new to VBA or you want to sharpen your existing VBA skills then why not try out the The Ultimate VBA Tutorial. Excel VLOOKUP not working - solutions for N/A, NAME and VALUE errors by Svetlana Cheusheva | updated on March 26, 2018 134 Comments The tutorial explains how you can quickly cope with VLOOKUP not working problems in Excel 2016, 2013, 2010, 2007 and 2003, troubleshoot and fix common errors and overcome VLOOKUP's limitations. It comes as part of Microsoft Office 2010 , which also includes other leading apps such as Microsoft Word and PowerPoint. To work around this issue, set the ScreenUpdating property to True before you call the. 11/21/2017 · Excel formulas are not updating. Excel AutoSave not working on Windows PC, how to fix. MS Query gives Excel users the ability to access 3rd party databases, text files, and Excel workbooks as relational data sources. When you try to refresh the pivot table data, Excel can't find the data because it's referring to the wrong/incorrect table name. However, Excel online does not have 100% of the features of the local install application. Worksheets(sheetName). (NOTE: Planning to build or manage a VBA Application? Learn how to build 10 Excel VBA applications from scratch. The MakeGraph subroutine takes as a parameter an array of values and some optional titles. I have confirmed that "Add Links" is checked in Preferences. I found that by right-clicking the embedded object I got a menu where I could convert the Excel 2003 object into Excel 2016 format. I have been successful at preventing Excel from coverting that long number into scientific format. The Find function finds only what you actually entered. The problem is I don't know the work around for this. An alternative could be to change the table name to the name the pivot table is expecting. When I try to refresh the data i'm not able to click the refresh button. I am having the same issue. I downgraded from Acrobat DC to Acrobat XI and now have the issue that links are not included in my PDF. This is on Windows 7 64 bit. This is because the execution service account does not have access to the Excel file. Formulas are the key to getting things done in Excel. Like the Accounting format, the Comma format inserts commas in larger numbers to separate thousands, hundred thousands, millions, and. Select Workbook from the left dropdown. Alt Tab not working with Excel – Sometimes this issue can affect other applications such as Microsoft Excel. Posts will alternate between Excel and engineering/science topics, with the occasional post related to neither when I feel like it. How to use NETWORKDAYS in Excel - formula examples. When I use the delimiter “;” it does not work. When you run a macro that calls the Workbook. I've tried AppActivate, but it appears to have no effect. The first time causes it to start blinking, and the second time gives it focus. Maybe it's an isolated incident on my computer, but worth a try if you're having the same problem. We have Ncomputing Vspace running, with 5 terminals all linked to AD server 2012. Excel Copy/Paste feature not working on General Entry modified window If you have grown used to the relatively new Excel Copy/Paste feature in the General Ledger Transaction Entry, you are probably enjoying the benefits of collecting journalized spreadsheets from around the company and simply integrating these into Microsoft Dynamics GP without. Troubleshooting Analyze in Excel Thanks, Lydia Zhang. What I mean is, I tried putting the code above into an Excel Macro, behind a "Start Button" (Insert button wrote, "Start", assigned macro), opened Notepad, tried to run the macro and it did not work. 5 and the free excel is only available for devices that are 10. Activate method in a Microsoft Excel 2013 workbook, the workbook is not activated if the ScreenUpdating property is set to False. org/up-down-arrow-keys-are-no. First, as Mary noted, text wrapping has to be turned on for the cells. Until today, when all the Word invoices that I had converted as per above suddenly will not open and are not even recognised as Excel objects nymnore. Sometimes it sends the keystrokes to the correct aps, sometimes it sends them all to a single ap, somtimes it doesn't send any at all. But not all applications expose themselves (so to speak) to such automation. I thought, good, Ill save it, did that, but they still dont work in Excel 2010 or 2013. Excel Numbers Do Not Sort or Add Correctly Last week, I heard from someone who was having a problem sorting some numbers in Excel. A comprehensive list of defect corrections for major releases, refresh packs and fix packs of IBM Cognos TM1 10. It just sits there for a few seconds; then nothing. That is where we are now, how do I get all my old excel, matlab and vba projects into python? The first step is to install python. But here's the issue - the filtering function doesn't work anymore. Another reason why your Excel filter may not be working may be due to merged cells. Secondly, Microsoft developed a feature for Excel that Lotus didn’t provide in 1-2-3, namely PivotTables. Excel AutoSave not working on Windows PC, how to fix. There are data, charting, time saving, and specialty add-ins that make Microsoft Excel easier to use. The system requires. Microsoft Excel 2013, free and safe download. Paste the following code into a new code module, and run the macro ActivateExcel. Excel shortcut does not work keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. NET developers joined together with a common goal: to learn, teach, and have fun programming. If you look at the title of this article, it almost sums up what Microsoft Excel is. any advice how can I fix this problem Thanks AlerT. It will, however, print off of "Paint" and Adobe pdf docs. To check for page breaks: Enable the display formatting option on the ‘Home’ tab, under ‘Paragraph’ Look through the table for a page break and delete it, if there is one it will be at the bottom of the page (hence being a page break). Select your version of Microsoft Office or Excel. The command that fails is "Appactivate conExcelTitle" where conExcelTitle is a constant set to the title of the Excel page I'm moving back to. NOTE: These functions work only with Excel's 56 color pallet. appactivate command doesn't work. When the workbook is not maximized and the title bar says Microsoft Excel AppActivate ("Microsoft Excel") works fine. Does AppActivate not work with Windows Explorer? > > > > > > Thanks Last edited by Daniel Duta; It's not a bug--it's a feature. I am at a loss for why it works for me on one laptop but not another. We use MS Excel 2003 on XP. xlsm) with extensive calculations running through VBA coding. Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services. When xlsread calls the custom function, it passes a range interface from the Excel application to provide access to the data. Free Excel Template Downloads. Instead of "Uninstall", choose "Change" right next to it. Problem is, the open window keeps popping up in the last folder I was in, instead of the one I'm trying to direct it to with ChDir. A comprehensive list of defect corrections for major releases, refresh packs and fix packs of IBM Cognos TM1 10. It would probably be better to give an example. Select all Open in new window. "Excel is not responding" "Excel has stops working" So you are probably wondering: How to fix Excel not responding? We are helping you. The following steps resolve the issue 1. I've tried using the AppActivate function with little success and I'm not entirely sure that that is even the function I want to deploy. Any suggestions? ch1616 - 1002643. Before you press the button, the image is not part of the file. Excel formulas not working, not updating, not calculating: fixes & solutions by Svetlana Cheusheva | updated on January 9, 2018 199 Comments This tutorial explains the most common mistakes when making formulas in Excel, and how to fix a formula that is not calculating or not updating automatically. Excel is pretty intuitive and a basic course in Excel should be enough to get you started. i´d like someone to explain me why instruction APPACTIVATE doesn't work on my excel2013. I was trying a few times to put some applications to check out and nothing worked. I changed: AppActivate "Microsoft Excel" to. The realization that real programming languages exist and are used every day for data anaylsis that do not cost a dime and work very well, but may have a bit of a learning curve.