autosave

Hi All. Since this morning, AutoSave button automatically added to my quick access toolbar. This is just so inconvenient as I have been using the same shortcuts for 8+ years. Alt+2 = Special Paste, Alt+1 = Format painter and so on... Now excel decides to place this button to No1, and it is...

I have a couple of spreadsheets that run some validation code when the 'BeforeSave' event is triggered. With the new autosave functionality (saving the document to Sharepoint on a very frequent basis), this causes two problems; (a) the code errors out, because the save still happens with the...

Hello, I'm new to VBA and excel but I've been stuck trying to figure out how to do what I need. I have a single excel spreadsheet named ShipTask1 that stays open always. I need to auto save at 7am and 7pm every day in a certain folder with Date_Time_ShipTask1 as the name and in PDF format. I...

Noob to VBA here, apologies in advance. Haven't even thought of macros in years, and searched the forum and can't quite piece together the parts to what I need. I have a spreadsheet for daily jobsite use...completed by the crew and used by internal departments for payroll and billing. Boss is...

My spreadsheet uses webqueries to get data from the internet, use that in calculations, and publishes it as a webpage. Works perfect, but the webpage only gets republished when I save the document. I would want for the pages to be republished on an interval, or better yet, the document to be...

Hi folks. I have created a Userform that transfers data from the form to a worksheet at the click of a button (cmdSubmit). What I'd like to do at the same time is copy the destination worksheet (or the whole workbook?) to a new folder elsewhere, just in case the original gets accidentally...

I've found code to autosave every 5 minutes by creating a VBA module, but they all seemed to require that the workbook be macro-enabled. Is there a way to do this while keeping the file extension as .XLSX? Maybe using the Personal.XLSB file? Or a different method?

Hello All, I looked around for a solution to this but was unable to find anything. If someone could point me in the right direction it would be greatly appreciated. I am using the following that I found on VBA express to save one sheet of a workbook as a new workbook in .xls format while...

Using Excel 2013. I have used the autosave function frequently. I know to go to File->Options->Save and enable. -Boxes for for "Save autorecovery" every 10 minutes and "Keep last autosaved version if I close without sending" are checked. -Autorecovery file location...

Hello, I need HELP to automate a monthly recurrent task. (excel 2007) Create "invoice like" PDF's based on table in one sheet. Rows 1-6 are "Logo, headers & Cells with Sum of filtered data" DATA to Filter is in Table A7:F xxxxx (normally has not more than 100.000 rows/lines) Header Columns...

I have a problem with saving a file in excel. It is an existing large (25MB) file, which I have saved several times on the same location. During my last session, I got the following errors: when excel was calculating a big calculation, the following error occurred--> excel cannot complete this...

Is there any way of accessing Autorecover manually ? I thought I had deleted a worksheet. I knew that (foolishly) I had not saved for a while. I also knew that if I closed Excel, I would lose any autosaves. I failed to find anything. For next time, is there a way out ?

I go into Options | Save and see that they are supposed to be auto-saved every 5 minutes to: AutoRecover File Location C:\Users\user2\AppData\Roaming\Microsoft\Excel\ But when I look in that directory, I dont see ANY saved files. Why not? What can I do to fix this?

Hi all, I've created the code to check for a file nmae already existing and if it doesn't then the code creates the appropriate data in the sheet and then is supposed to save it into a folder. When stepping through the code to make sure it works I am getting a popup window saying: Run time...

Hello there, i'been posting this same question in almost every excell forum without am accurate answer, I'm almost givin up!:( I have this code for auto increment cell "E5" upon open an invoice template: Private Sub Workbook_Open() [E5] = [E5] + 1 End Sub All I need its a piece of...

Hi All. Why do I get a warning stating that there are xml macros and personal info that inspecter can't take out? It pops up every time I save spreadsheet and also when it autosaves. How do I disable or workaround that so it doesn't come on. PS: I am quite handy with VBA code, so don't be shy...

Hi All Quick help required: I am using excel for dashboard presentation over intranet this main file needs to be updated after every 10 mins as we all know excel republish htm after saving file i want this saving process to be in background not by auto opening workbook again and saving it...

How do I make a copy of a worksheet in excel as a backup in the same workbook before making modifications? Please help. I need the excel to do this automatically in the beginning so that when user starts modifications the original sheet is backup automatically. Thanks

My boss was working on a spreadsheet in Excel 2002 - she accidentally closed the file without saving it (she had a couple of hours worth of work on the sheet). Is there a way to recover the document? Does Excel automatically cache documents to a default directory? if so, where? Any...

Hello Boffins. My workplace uses a shared XL spreadsheet which is basically a huge calender of out outbound freight history. Dates along the top and stock numbers down the side. Eg We send out stock 111 on the 21/03/09 and it comes back on the 28/03/09 those cells are highlight green when it...