@DustinB3403 if you have them filtered down and want to cut/paste to another tab, you can select "visible cells only" by going to Edit / Go To... / Special... and select "visible cells only" to cut/paste just those rows visible in your selection.

@shybrsky you really should upgrade to Windows 10 if you have to use Windows. I know the PowerBI desktop application is Windows-Only so this is a requirement for many who need to create and edit dashboards. If you're only viewing content though you can use any modern web browser and operating system you want.

I have seen weird/slow response with the video/hardware acceleration turned on. Try disabling it.

@dashrender said in Excel - auto recover: @scottalanmiller said in Excel - auto recover: @dashrender said in Excel - auto recover: @jaredbusch said in Excel - auto recover: @dashrender said in Excel - auto recover: @jaredbusch said in Excel - auto recover: @dashrender said in Excel - auto recover: @scottalanmiller said in Excel - auto recover: @wrx7m said in Excel - auto recover: That is why I tell people the policy is to reboot every night before you leave for the day. Most people do... some don't. This is the exact reason why this is the policy. Yup, I agree, end of day reboots are the smartest if you can get people to do it. Most of our people do - the few (really the one) who doesn't is also the one in charge. I can't make them. Sure you can. If it is company policy, you simply create a schedule task to reboot machines. LOL - You're on a roll today! Just stop covering up bad behavior. You, and others make it sound like I have a choice here - I only have two choices, perhaps three - 1) quit 2) according to you all ignore her 3) just stop talking to you all about trying to find solutions to provide to attempt to fix things. No, you are missing the one thing we all recommend... The CTJ talk. The talk where you give her the options and make her choose. You don't make up the options, you just enumerate the ones that exist. No one has suggested any of the things you think we are recommending and missing the one choice we almost all agree on. Can you spell out those options, apparently I've missed them.. .I feel like I've already gave her said options.. and she chose the one not on the table - to do nothing and still complain about it. At which point, my option option is to basically ignore her - stop caring, whatever you want to call it, it's basically the same thing. You can come up with the range of known options. Examples: Use Google Apps and live with their save mechanism. Use local Excel and live with it's save options, either auto or off. Use Excel online and live with its save options. Use a different application, like OnlyOffice. Use Excel with auto save but get a "save all changes" storage system like Exablox Tell her what is possible, that's your job. Afix prices and info to each. Then make her decide. Then any complaints you just tell her "hey, talk to the person who made this decision... you".

The system was set to automatic.

Use Drupal. It's almost purpose built for this type of stuff. Custom content types and views make anything possible.

OK so it's a complicated pivot table but it still a pivot

Also this is what I've done, but modified the latter half of the page to keep everything in place.

Well the report is automatically generated from a system we use here. So if possible, rather than having people have to open 2 files, I'd like the modules to just import when excel launches. I suppose I could bury the modules into the personal file. But I'm not sure if that't the best approach.

@gjacobse said in Need recovery software my excel files got corrupted in my pc : @RoopanKumar Were you able to resolve your Excel issue? I'm going to assume so and close this one out.

@Carnival-Boy said: the wonderful, and under-rated, Microsoft Access. Die in a fire heretic!

@JaredBusch said: @scottalanmiller said: If you learn a language just to do this, Python would be my recommendation. Specifically well suited to learning, good for doing small scripts of this nature and good for list processing like this. It's just a good fit. But yeah, if you know some other language already, definitely go with that. I dislike any whitespace delineated language. I do hate that aspect of it, very Fortrany, but it does make readability a clearer priority for the newbies and can have benefits, especially when working in teams of non-full time programmers.

Creating a new document made a difference. I've known that I needed / WANTED to recreate many of the forms and such we have for HR and the departments. A vacation request was created in WORD and dumped to PDF, which forces a person to use a pen to complete it. A form would be better... Especailly now with the options of OneDrive and Sharepoint....

@g.jacobse said: @ajstringham said: @g.jacobse said: I'm not sure how much I can offer - it's a protected sheet, we are only allowed to enter some data. But there are 4 date fields and a day calculated from that. Start Date; Release Date; First date of month, last date of month. Here is the formula which is in column "K": =IF(ISBLANK(H5),"",IF(ISBLANK(G5),"Enter START DATE to calculate",IF(AND(MONTH(EOMONTH($A$2,1))>MONTH(G5),MONTH(G5)>=MONTH($A$2)),IF(ISBLANK(F5,EOMONTH($A$2,0)-G5+1,H5-G5),"START DATE MUST BE >= "&TEXT($A$2,"mm/dd/yyyy")))) Column Fields: e= Arrival Date f= Release Date g=Start date h= end date k=#of days formula above Based on what I've tried,.. the formula works as long as you don't enter anything in the Release date. Once you enter the release date, the #of days drops by 1. I'm told it works 'correctly' on one computer. I've tried two computers here one with 2010 and one with 2007 and get the same result. count is off by 1 (30 days rather than 31). I believe the MONTH variable is 30 days. That's probably where the issue is. I can see that being the case. However: Why would it work on one computer and not on any other. That is true. A curious case...check for a macro of some sort maybe?