Excel Product Key 2017
Leana Eckes
I just spent two hours on an excel file only to have excel crash before i saved it and lost my work. I am using MS Excel 97-2004 on a MacBook Pro and right now have to manually save all work. How can I set up MS Excel/Word/PPT to auto save every 10 minutes to my Business's Dropbox account? I want to be able to work without having to manually save my file every few minutes.
There isn't a way for Dropbox to do this but as I understand it there is an auto-save feature in Microsoft Excel. I believe most versions have this. Take a look at this article -us/article/use-autosave-and-autorecover-to-help-protect-your-files-in-...
If you're referring to auto-saving directly to your Dropbox account then it's very likely that Microsoft prevents that as a way to force OneDrive use. There are even topics on Microsoft's forums that discuss this, and the usual answer is to use OneDrive.
However, the auto-save feature just needs a folder on your computer, and you can easily specify your local Dropbox folder. Any files that are auto-saved to the Dropbox folder are then synced like any other file would be. I have my local Dropbox specified as the auto-save location in Excel and it's never been an issue.
The floating Dropbox logo is the Dropbox Badge. It doesn't allow simultaneous editing, but does alert you when others are in the document and it allows you to load the latest changes if any, among other things. Simultaneous editing is possible and has been for a long time through the Dropbox website (the same way Google Docs does it).
Hi,
i wrote a script which exports to a CSV with the Monday API Formulas get parsed with formula.js:
You need an developer account or an API Key => just ask your admin. If you have any questions just ask: k...@1ln.de
script:
you probably found a suitable workflow in the meantime, but I still want to recommend another possible solution. Our Exported Excel Cleaner does the job with ease, and includes just a little manual effort.
Since you explicitly mentioned restrictions and maybe security concerns in using third party apps, I want to add that our app is running client-sided only. That means, no data is being looped through any server, everything is handled in your browser.
Thanks for your reply but just what i mentioned, sould be integraded in Monday. But in meanwhile we are testing the export through an API connection and that works great. 1 refresh and we have the realtime data from monday in excel.
I am trying to see if there is a way to easily print each sheet in my excel workpaper to PDF (would be helpful if I could select which sheets too). To give more background, it's a workpaper that has several sheets for invoicing purposes, and I'd like to easily drop the file in and run a workflow that will print each invoice to PDF. However, I'm not too advanced in the reporting tools. Also, I'm not sure if it's possible to use one input tool for something like this, or if I would have to manually add in a input tool for each sheet/invoice. It'd also be extremely helpful if I could also use some sort of dynamic naming for each output based on an invoice # listed in each sheet if possible.
I've a workflow that generated output to 2 sheets of the same excel file. Both sheets contain the same data. I want this excel file to be emailed to a recipient at the end of every run. Please let me know how this can be achieved.
Hi @mercurial_maverick, I often create the output path for the excel file in the formula tool and use it in the Output and Email tools to attach the created file within the email tool. I have attached a sample workflow for you to reference.
As a follow-up to my previous post, I would be suggest being careful with the Email tool. By design, the tool sends an email for every row of data coming into it. Hence to avoid duplicates, folks tend to use the sample tool just before the email tool and restrict it to 1 row.
Thanks very much. I used your workflow and it was close to the final solution. My final solution was to exclude the sheet part in the formula tool. It seems like the full path with sheet name in the end does not work.
Thank you for sharing this! Just spent a long time trying to figure this out and removing the sheet specification entirely worked. I was assuming that the Email tool would require specifying the "SheetName" like with the normal data input and dynamic data input tools, but it turns out it will throw errors if you have anything after ".xlsx" in your filepath field.
I don't know if anybody else has ever seen this issue, I've been an Excel user for 20+ years and it's the first time - I literally sat and watched Excel automatically undo all of my changes for the last 15 minutes (as if I had Ctrl + Z stuck down) over all 5 spreadsheets I had open. I didn't save afterwards, and when I reopened, the file came back correctly as if the undos had never happened.
@HelenaDavidson exactly the same thing has just happened to me. It was more of an issue for me because this was an "auto-save" SharePoint file, so I couldn't just elect to not save it. I also had problems with restoring a previous version (error message along the lines of I needed to save unsaved changes first. I saved it, closed it, re-opened it and tried to restore again but same message). In the end, I went back to an earlier copy with a different name and re-started from there. I was able to reproduce the behaviour by repeating the amendments but eventually cleared it by saving a fresh copy immediately before taking the action that caused the circular reference, which I then resolved, like you, by pasting values. The other feature I noticed, after the repetitive "Undo" of all my work, was that some formulae had not re-calculated (I had to go into editing the formula and press enter before it re-calculated). All very mysterious and presumably a subtle bug within Excel. Sadly, no one else seems to have encountered it yet, so little chance of a fix but truly very scary! Like you, I'm a very experienced user of Excel and I'm sure it wasn't just a silly mistake by me. The only thing remotely like it I've ever experienced is when Windows decided that it thought I was repeatedly pressing the down arrow key, which was only recovered by pressing the power button long enough to force a shutdown. Possibly a driver error. I toyed with the idea that this repeated Undo might be a repeated CTRL Z being processed but there's no evidence that it was still repeating after finishing all the Undo actions and finding you with the same experience after the same actions very much suggests an Excel bug.
@HelenaDavidson - My colleague has the same problem. Upon researching I found out that undo stack seems to apply across workbooks. Right now, we are testing to open a new excel in a traditional way from the start menu in windows to launch excel then pressing alt key to open a new instance. the immediate benefits is that you will have a separate undo stacks.
@HelenaDavidson This just happened to me, I received a circular reference warning and before I could fix it, I was stuck watching excel automatically undo all the changes I made (in several workbooks) for the past 20 minutes. I was not able to re-do, and could only open a previous version, and try again. I have never had this happen to me before. I see some others have had a similar issue, but I haven't seen a root cause. I certainly don't want to go through this again. Any one else been successful in finding out what caused(s) the automatic undos?
I have been very satisfied with it until about 6 months ago I started having issues when I have been working on several different pages in a work book, then when I go and copy data (right click, copy then paste), from an existing document all of a sudden Excel automatically un-does all the work done on all the pages.
@HelenaDavidson We have a spreadsheet that is automatically updated by a utility. It creates circular references every day, and the spreadsheet has to be edited and tweaked up to make it pretty everyday regardless of whether there are circular references or not. You have to open it, fix all the circular references, save it, and close it. Then when you open it again, you can work like normal without issue. If you leave a circular reference or don't get them all fixed before Excel checks for them again (I don't know if there is a timer for this or something else triggers it), all your changes will all get backed out and you have to start over. Based on the other comments, I agree that it's caused by the circular references and whatever process Excel uses to find them. I hope it gets fixed too.
@JS4269 that's an interesting observation, I've only had it in the context of a circular reference on a particular operation and I now try desperately to avoid such references and immediately correct them if they should occur.
I'm getting many of the odd behaviours detailed above, including no responding when trying to select a cell, pasting text and suddenly getting many undos, having to go into each cell to activate or redo the formula. With some the cells which have been used to join text from a number of cells the result is still right after the undo happens, the reference cells are wrong but when I hover over these cells it shows more recent text but actually won't let me change the text in the cell. This happened once so the detail here may be slightly inaccurate.
Here's a trigger I found for the unintentional roll back of all changes. I can recreate the problem using this trigger once the problem has occurred for some reason. However, after a reboot, this problem trigger doesn't work again until the roll back changes problem happens for some other reason. Here is the sequence:
7fc3f7cf58