I created a five year pro forma financial model for my business. The spreadsheet makes extensive use of worksheet formulas and macros. I also added a sheet to track actuals (numbers extracted, by hand, from QuickBooks monthly).Certain formulas in the spreadsheet are based on values that do not change over time. For example, I assume that my widgets will sell for some unit price and monthly revenue forecasts are calculated as the projected sales volume times the unit price.Here's the problem - let's assume that my sales price changes at some point in time, after sales revenue has been generated. If I simply change the price, which is applied globally, then the historical 'projections' will be wrong.Just to be clear: When the model was first built, it assumed that widgets sell for $100 apiece. Assume that unit sales are the same as the month number. Thus, my revenue for the first six months would be $100, $200, $300, $400, $500, and $600. Assume that for the first three months, I hit my revenue numbers. In this case, the sheet that tracks actuals would show a $0 difference, for each of the first three months, between projected revenue and actual revenue. Since business is doing so well, I decide to increase the price of the widgets to $150 on a forward-going basis. Suddenly, the spreadsheet now shows that I failed to meet projections for the first three months, when, in fact, I did meet them!It seems to me that there should be some way to lock cells in the spreadsheet based on the current date. For example, when I open the spreadsheet in June, I should be able to programmatically protect cells from May and earlier. Is this possible?
I've created a workbook with about 15 worksheets and prior to sending to the customer I want to lock the cells so that they can't be changed without a password. So, I first select the cells I don't want to be altered and lock them. Then I go to "protect worksheet" and after checking the box that allows people to select cells in the locked section (selection of sells in unlocked section checks automatically) I enter a password twice and the worksheet is theoretically locked.
I can still change cells in the locked area. It didn't work on any of my worksheets. So I went back and unprotected the sheets and then selected and locked the cells TWICE, after which I protected the worksheets again. This time some, but not all, of the worksheets had locked the cells protecting them from editing. I then tried to go thru the same rigmarole but locking the cells three or four times before protecting the sheets for the sheets that were still unlocked, but that only worked sporadically as well. Sometimes I had to dis-allow selection, lock the cells in the sheet, unprotect it, lock the cells again twice, and then check the select box and protect the sheet AGAIN. That FINALLY worked.
I have numbers e. g. 1 to 100 in excel in a particular column. If I remove any number e. g. 13 & keep that cell blank. Further cells should get automatically numbered from 13 onwards.
Been having some problems with excel getting it to behave like Iwanted, tried google around but so clueless as to what to call things that it makes it hard. What I want is for a cell formula to do as I want when I pull on the lower-right corner down.Normally it the adds 1 to every cell address, but I need some of them to remain the same while others change. More exact:I'm trying to make excelsheet where one collum is supposed to have the formula:
=F3*Dx/D3
x goes from 3 to eternity, while F3 and D3 should remain static while doing that drag thing. I remember there was a way to mark F3 and D3 so they don't change, but can't remember how.So F4 has F3*D4/D3, F5 has F3*D5/D3 and so fourth.
the problem i'm having is that .exe files are getting locked for around 5 minutes when other programs try to access them this means i can no longer access them for read write copy or delete. once they unlock they are deleted automatically.does any know what the problem is ? i am running windows 7 32 bit and have customized it a lot, by disabled unwanted services, i think it may be one of the disabled services that is causing the problem, but i don't know which one it could be.
I've been having issues with Windows 7 locking up and failing to boot. At first, I could get into windows and it would freeze with an error message saying something about processes causing it to stop responding. The mouse wheel would just keep spinning and I couldn't type using the keyboard or even ctrl-alt-del out. I ended up having to hard shut down. When it rebooted, it wouldn't even load Windows and it would just stay stuck on the BIOS screen...I couldn't even F2 into the set-up at this point.I shut everything down and disconnected the SATA connections (the HDD and the CD/DVD). This time I was able to F2 into setup and checked the settings. I don't overclock and everything was set to default. I hooked the HDD and CD/DVD back up and restarted. I got into Windows Safe Mode. It ran through a driver install and had me restart. When I restarted...Windows came back up and immediately did the freeze thing again. Once again, I had to hard shutdown and it wouldn't go past the BIOS screen or let me into the F2 set-up.
I started up and shut down a few more times trying different sata ports with the HDD and CD/DVD. One time I got it back into safe-mode but most of the time it just stops at the BIOS start screen. I switched the RAM and reseated the video card thinking it might be a hardware issue.
Kind of a wierd one, at least for me. All of a sudded, whenever I type the letter"l" in any program, I get the blue locked screen. All I need do is hit enter or click the user icon( since it is not passworded) but does anyone have any idea what's going on here.Running Win 7 professional 32 bit.
Laptop keyboard will lockup. It is a HP laptop model G72-259WM. I was able to hook up a usb keyboard to log into computer but it will also lock up when I tried to do some typing in Word. Uninstalled keyboard from device manager and everything worked ok for two weeks and it started acting up again. Had him uninstall keyboard again from device manager. For now it is working ok.
Just randomly, regardless of what my CPU, Memory, or Hard disk usage is, and regardless of how long the system has been running, it seems like at some point, every time the system hangs to a point where I can move the cursor and the numlock lights will still change when pressed, but that's it. Nothing else. I'll look down at my tower; no hard disk activity. All of my programs will show the hour glass cursor (in my case a spinning black and blue ball similar to the spinning beach ball in OSX (aside from the point.)A look at the Event Log shows these events occuring, some occuring at different times, but all of them occuring with the same Error Code of (7011): A timeout (30000 milliseconds) was reached while waiting for a transaction response from the Schedule service.That error has appeared shortly before each of the freezes it seems, and has occurred for these different services: NlaSvc, Ralink UPnP Media Server, CryptSvc, NIS, and Dnscache.I tried reseating my SATA cables, and so far the system hasn't hung again, but I'm a bit worried that my hard disk might be failing at the same time.
Everytime a file is created in a particular folder it becomes Locked, I have not turned anything on, or changed anything, I even did a system restore to 2 days ago when this behavior wasnt taken place...I have assigned "Everyone" as permission to these files, but everytim a file is locked.why has this behavior changed, and how can i leave the file as "NORMAL" meaning no need to assign permission for eveery file that is created!
I've been working with windows 7 and I recently reformatted up 7100 x64.
I am noticing a new problem that I didn't experience in build 7000 x64. Basically my the screen locks up but I am still able to use the mouse and do things but the screen doesn't update. For example Im running FL Studio, and I load some module, then the screen freezes. Now I can still play sounds, exit software etc but nothing changes on the screen, its like clicking on a picture and navigating by memory. Eventually, the cursor disappears and I am forced to restart by holding the power button.
As I said, I have did a clean install of 7100 x64 the only other change is that I am using the 171.81 nvidia drivers instead of the older ones.
I have a backup drive on my computer (G drive). When G is unhooked Windows will not boot from the C drive. Is there something written on the G drive that's preventing windows from booting off the C drive?
Have a legit windows 7 ultimate(sp1) from my work. I haven't updated in a while but I doubt that is the cause. I tried uninstalling or disabling kb971033 but no luck. I've also run malwarebytes with no luck. I've run hijackthis and I will post log since I am not sure what to delete.
this problem started yesterday, randomly last night my Computer just locked up, out of nowhere, couldn't click anything, mouse icon was gone, keyboard unresponsive when I pushed caps lock the LED didn't change and ctrl+alt+del did nothing either, had to hold down my power button and restart that way, when I did restart however everything was fine again.
Then today, I'm on my computer for 4-5 hours, I get this random lock up again, so I restart everythings fine...then an hour later, I get it again.
I haven't installed any new software recently, I did install the new windows update AFTER the lockups today though. I built my computer myself 1 year ago the specs are as such
I'm not hearing any weird sounds when the system locks up (no beeping or anything to indicate any hardware issues) and it's 100% not a heating problem as on stress test my CPU/GFX doesn't go over 50/52 @ 100% for around 2 hours.
I came across some article some time back talking about how windows 7 will manifest itself inside the motherboard particularly the newer ones with the UEFI bios such that you will be unable to upgrade the motherboard at a later date and that it will also block installations of other OS like linux for example. Not that i have had to replace a motherboard before but starting with my new build im getting soon I'd like to keep my options open. What truth is there to these claims and if they are true are there at least ways to get around it; and then how do these fail "features" apply when win7 is running as a virtual machine rather than the host OS?
when sending mail with large photos windows mail keeps trying to send it and i cant cancel or delete it , and i cant open up live mail because its trying to send it ,
My computer has been acting up of late. It's been freezing up at random times (even if I am running nothing). Trying to open up Task Manager, I don't see anything that could be using the CPU, but yet it says that i'm running at 100% capacity. MalwareBytes isn't picking up anything. Neither is Avast.Also, when I try to run anything Microsoft Office related I usually end up with a lot of lag. I'm not sure if these two are related, but I just thought I'd mention it.
I tried searching first but I seem to have trouble finding the proper terms to narrow the search enough... So I just post this.I put together a HTPC for 24/7 usage (windows media center and iMON remote control, spotify, PowerDVD for Blu-Ray movies). Minimal amount of additional software installed. The problem is it locks up often. The whole Windows 7 goes fully unresponsive (all you can do is power off -> on). It rarely stays responsive for 48 hours. No crash dump is generated. The event log shows nothing special, mainly two error items, one related with errors on Microsoft Security Essentials and the other is Circular Kernel Context Logger session failing to start.The main question is: what is there to do, is there a program that could monitor which other program seems to halt the system? I'd hate to go through eliminating each and every software/hardware component... The second question is: just in case, does anything below ring any bells what might cause the problem?
Is it possible to separate icons on that taskbar, for example Internet apps be sperated from other apps and locked so I don't change the order)? From what I gathered from another post, Stardock Corporation - Software - ObjectDock Plus - Product Information, would accomplish this? However, ideally I'd rather not use a 3rd party app.
I got this desktop pc around last year but for some strange reason my pc will hardlock itself (screen goes black, monitor turns off but the power is still on, sound goes off, forcing me to restart my PC even though I attempted to alt+tab or cntrl+alt+delete and tried to replug my monitor back in to get some kind of menu up with no luck) while playing several games such as crysis, smite, metro 2033, and skyrim. While I can still open and actually play these games, I will eventually hardlock within 10-30 minutes. With skyrim ill hardlock automatically at the first part of the game when I exit a cavern.I've tried all lowering graphic settings on these games and still have the same issue.What is strange to me is that I can play battlefield 3, battlefield bad company, half life 2 mods, portal 2, amnesia, dead space, dead space 2, planetside 2, and arma 2 just fine.
Last night something horrific began happening that's continued today: Every few minutes the entire system locks up no matter what I happen to be doing at that moment: I get the hideous "Not Responding" message when I'm in Firefox, Word, and even in Windows Explorer..."OS (Not Responding). Between last night and right now, I've had to manually shut down the machine with the power button countless times; I have to shut it down and turn it on to be able to use my computer! Last week, I got a new PC with Windows 7 Professional 64 bit (from 32 bit on the old one). I somehow created THREE User Account Control accounts in an effort to set up a Standard account like I had on the previous system (Ellen-PC), so I wouldn't have to have permission to do anything. But I still need permission on the UAC I logon to now which is Ellen Administrator. I've tried to change it to Standard account with no success.
So my pc has been randomly freezing and locking up after an hour or two of use and i cant figure out why. I have updated my graphics card and bios. I have tried both ram sticks in individually into the first slot, so unless both ram sticks went bad at the exact same time, they should be ok. I did try to run memtest overnight, but upon waking i found that the pc had restarted. I have cleaned out the pc of dust, and the heat seems fine on cpu, gpu, and mobo. I have run a full av scan with malware bytes and cleared up registry and temp files with ccleaner.
Specs: Windows 7 professional 64 bit Intel i5-2500k cpu @ 3.3ghz 2 4gb sticks corsair vengeance ddr3 RAM P8p67 pro rev 3.1 asus motherboard 2 NVidia 560 ti's in SLI Crucial M4 CT064M4SSD2 2.5" 64GB SATA III MLC Internal Solid State Drive (SSD)
In the last two weeks I have noted that my Windows 7 Ultimate 64 Bit machine will boot, looks good and when I log into a user account the Desktop shows, without gadgets or icons and just sits that way for seemingly ever. Can't break in and must power down. I log into Start Normally and it will boot correctly. This has occurred usually in my user account and once on a rapid restart on the Owner account. I have used chkdsk to see if it is a physical problem. Out of my league but this hasn't occurred for 2 years and just intermittently occurring.
I restored my friend's HP Vista desktop to factory defaults. When I attempted the first round of 91 Windows Updates, 50 of them came back as Failed to Install. I thought maybe the Recovery went bad, so I re-did the recovery to factory defaults. I was able to install half of the updates, (I decided to do half at a time), but now it is locking up at random times. I ran the Windows Memory Diagnostics, found no errors. I ran chkdsk /r from a command prompt, it found no errors. Any ideas where to look next? I'm thinking to open it up and look for swelled up capacitors
My Main screen is locking up frequently. I am NOT a technical PC person, but what I have attempted in hopes of fixing the problem was to run a scan with my Kaspersky, ran a virus check and did a trouble shooter.
I started having a problem with my Toshiba Satellite laptop yesterday. Whenever I open a program such as firefox or chrome to browse the internet, it seems that certain parts on the computer screen such as the start menu bar on the bottom will stop responding completely. There are points where I cannot even minimize Firefox because the button on the top right doesn't respond yet I can open new tabs/etc. I usually have to ctrl alt delete and get to the task manager to reset everything, but about a minute later I will be able to go on the internet but not be able to open or even highlight shortcuts on my desktop. I thought it was the mouse/touchpad but I updated drivers and it doesn't seem like that is the problem. It is like one program on the computer will be fine while the others just go dead.
The past few days my computer has been locking up, always when playing a video game, and I am forced to press the restart button. When I log back in, I receive no error message from the action center or anything. When I check the windows event viewer I see the messages that says "The previous system shutdown at 11:24:39 AM on 10/6/2011 was unexpected." and "The system has rebooted without cleanly shutting down first. This error could be caused if the system stopped responding, crashed, or lost power unexpectedly." but none that actually tell me why it crashed or stopped responding.
System: OS: Windows 7 Home Premium Motherboard: XFX nForce 750i GPU: EVGA GTX 460 SSC CPU: Intel Core 2 Quad 9550 RAM: 8g DDR2 PSU: 750 Watts If anymore information is needed, please let me know.
I need a way to lock my computer without affecting any programs. I have programs running that access the mouse and keyboard functions. When I lock my computer, it disables the desktop access to these and breaks the programs. Is there any way to get around this in windows or maybe a program that will allow me to lock my computer without leaving the desktop?
I am running Windows 7 on my computer and have somehow used windows security to lock my seagate external drive. The computer can tell that the drive is there but I cannot access anything on the drive and also cannot write to it. I have tried talking to tech support from Seagate and they said that since I have used a third party program that I need to contact them. It is difficult to get a response from them. I am a novice when it comes to things like this.
Yesterday windows wouldn't get past the black log on screen. I did a restore from a couple of weeks ago and it started fine. Today, same thing. So I tried the restore again, using a slightly older restore point. It got me in and I immediately opened malwarbytes and updated the file but the system locked up before it finished. I tried opening in safe mode but it locked up again. I tried another restore but was prompted to run chkdsk /r because of freecell problem. Didn't work. I tried again and received unspecified error (0x8000fff).
