Lockergnome help - Excel - General Protection Fault Errors

Can I use solver function in a locked protected worksheet

I am using the solver function to optimize a blend of products I want to lock protect some areas of the worksheet but when doing so the solver function will not work and the following translated message arrives: The active document is not a worksheet is protected or shared Hope someone can help me Thank you Niels

Copying an Array formula

This has just happened to me have you figured out why? Vance K wrote: > I have multiple array lookups in one tab that refer to multiple tabs within > the workbook All of the formulas have copied just fine except the last one > It will only copy half way down the spreadsheet When I try and copy it dow > or input another formula the cell just stays blank Has anyone seen th

Excel 2007 data not showing until clicking cell

Ken You might find some ideas here http: smurfonspreadsheets wordpress com 2009 04 14 excel 2007 screen video issues and the other posts that it links to Specifically check which add ins you have loaded normal and COM and any auto start workbooks look in the XLSTART directory in particular pdf creator components Cheers Simon Excel development website: www codematic net

Name conflict

Line print errors not supported

How to open a file with a link error?

When trying to open an Excel File that contains some hyperlinks to the web I get an error message that an automatic update of links has been disabled I went to Excel Options>Trust Center>Trust Center Settings>External content and made sure that I had checked the prompt user choices Then when trying to open the file I get the same error dialogue box That box has two choices

Excel Error

Hello I tried to Uninstall Office 2007 Enterprise because of a problem with Outlook The uninstall stopped with Error Message Code 1402 Cannot open the registry key UNKNOWN\Excel Sheet 8\CLSID and then rolled back Now when I try to open Excel the windows installer appears and the error message re appears and then rolls back and states a fatal error when installing I have been on REG

Error when a file is opened in Excel by the toolbar icon

I met a very strange error On a netbook with windows XP Home edition installed by vendor I installed Office 10 XP Pro When I open a file in Excel by a command from the menu it works just fine but when I try to open a file by pressing the toolbar icon I receive an error in module msvcrt dll and Excel closes and opens again recovering fhe file Then it works The same Office package works

Excel problem

What antivirus software are you using and when was it last updated? srw wrote: > I have just starting having a problem whenever I click on the File word to > access the pull down menu it locks up for about a minute or so I can hit > CTRL P to print with no problem but can t click for that pull down menu I > tried to Detect Repair but it gives me error 1402: Setup ca

Fill Color from Home Ribbon Not Working

When I use Auto Filter to filter specific rows in my worksheet so that I can shade the background color of the cells it works the first time I do it using the Fill Color icon tilted paint can on the Home Ribbon but when I change the filter and choose a different Fill Color using the same icon from the Home Ribbon Excel 2007 does nothing The color remains unchanged Has anyone

Excel 2007 rendering problem Data disappears reappears

Gabe Not that I know of Same problem One other problem is when we put the cursor on the formula bar the mouse scroll button is inactive Only way to scroll is use the slide bar on the side Hopefully MS will resolve when the final product is released Dan Gabe wrote: > Hi Has this problem been resolved? I am downloading the latest updates but > am having the same pro

Excel found unreadable content in

Hi all I got the same in an advanced Excel file I use at work to create a test specification After converting from Excel 2003 to Excel 2007 we saw this problem on my Chinese colleagues PC s when opening the file Many speculations about what caused this but down to earth the problem is that the file was created in a Danish PC Regional Settings Solution: Change Regional Setting to En

When saving an Excel file the program crashes

We get the following error saving a Office 2007 Excel file Have no clue why we are getting it Any help would be greatly appreciated Log Name: Application Source: Application Error Date: 10 8 2009 9:56:59 AM Event ID: 1000 Task Category: 100 Level: Error Keywords: Classic User: N A Computer: TERMSVR hillcrestnh org Descrip

Formulas are being deleted and changed to = N A

This is a known issue with 2007 and the xls file format we fixed it by moving to xlsm see here for more info and fellow sufferers: http: smurfonspreadsheets wordpress com 2009 02 23 excel 2007 na error Cheers Simon Excel development website: www codematic net Pluto wrote: > I ve been having the same problem as well > I ve created the spreadsheet on the same computer t

using the random function

RAND is volatile Whenever you make a change on the worksheet simple RAND functions re calculate Gary s Student gsnu200906 aries wrote: > I have made a 10 x 10 cell table with the formula =RAND 100 in each cell > > When I copy and paste one cell onto itself or another within the table all > of the results change within the whole table > > As a matter

troubleshoot long text wrapping in Excel cell

Nat I appreciate this post is quite old now but I was wondering if you ever found out more about how excel handles this problem and whether there is a workaround? I ve also struggled with this throughout my time working in Excel: primarily two issues: inability to use autofit to size rows to fit text occasional and unpredictable refusal to acknowledge carriage returns within cells w

How to Handle Remote Tech Support

chris@lockergnome.com (Chris Pirillo) — Mon, 13 Jul 2009 06:30:00 GMT

Using GoToAssist is the easiest way to view and control another person's computer online. Use it to provide instant technical support to family, friends and customers. Start a session with just one click, and instantly connect with the other party.

Network Tools for Windows

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

You need these network tools, no matter which operating systems and networks you have to support. SolarWinds ipMonitor: Affordable Network Monitoring for SMBs. Get turnkey network, server and application availability monitoring with SolarWinds ipMonitor v9.0. This easy-to-use, reliable solution for SMBs delivers out-of-the-box availability monitoring so you always know exactly what's up with Active Directory, DNS, Exchange, FTP, Web, IMAP, MS SQL Server, and SMTP. Download your free trial today. Or, try their totally free tools! And, through 2/29, save 20% when you purchase ipMonitor 9.0.

Get Your Own Web Site

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

Starting at just $3.99/month, web hosting from GoDaddy includes 99.9% uptime, 24/7 support and free access to GoDaddy Hosting Connection, THE place to install over 30 FREE applications sure to help you get the most from your hosting plan and Web site. Enter code CP2 at checkout, and save an additional 10% on any order.

Plus, as a friend of Chris Pirillo, enter code CHRIS7, that's C-H-R-I-S and the number 7, when you check out, and save an additional 10% on any order. Get your piece of the internet at GoDaddy.com.

VMware and Parallels for Virtual Machines

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

It doesn't matter if you're running on Windows or Mac OS X - every power user needs either Parallels or VMware (or both). There's never been an easier way to test software without destroying your primary operating system's stability. Think of how many times you wish you could press a 'reverse' button on your computer. Plus, there's no easier way to try new Linux distributions - see what all the fuss is about. Run Windows in OS X, run Linux in Windows, but the best way to do either is with VMware and/or Parallels.

Coupons for Online Shopping

chris@lockergnome.com (Chris Pirillo) — Sat, 12 Jul 2008 07:56:13 GMT

This feed is fueled by Lockergnome Online Shopping and Coupon Codes

Before you shop next time, see if we have a coupon first.