Over 1 million tech questions and answers.

Help with Excel!!! PLEASE! My Job depends on it!

Q: Help with Excel!!! PLEASE! My Job depends on it!

Oh please someone save my bacon!!!!!

I have a new job with a Time Share Resort. In these trying times, I'm trying to make the best impression I can. I am building an Excel Spread sheet that will allow others to enter data that I will then compile and create reports with.I just can't figure out how to write this formula or if it can even be accomplished. I have 1 column (Column A) that other users will populate with Room numbers. I would then like the second column (Column B) to auto populate with a Home owner's association number and a 3rd column (Column C) to auto populate with the average rack rate for that room that referenced from hidden columns. I have 3 pre-populated columns hidden, titled (Column R) Room Numbers (Column S) HOA numbers and (Column T) average Rack Rates. The Rows in the columns (R, S, and T) reference each other: example: If R1 is Room # 1001, then S1 is HOA 1, and T1 is $212.00. So if someone types in 1001 in A7, then the data that corresponds from Column R, in this case 1001 will reference Column S and Column T and auto populate that info into Column B7 and Column C7, respectfully. Is this impossible to do? Or is there a simple formula or macro that can be written to accomplish this?

I truly, truly appreciate any assistance I can get!
Cuban Missile

Preferred Solution: Help with Excel!!! PLEASE! My Job depends on it!

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Help with Excel!!! PLEASE! My Job depends on it!

Read other 8 answers

Hello all!
I have a serious problem with a program that my job uses. It is a virtual machine, which allows me to run a separate "machine" within my own. They use this so my personal side of my pc doesn't interfere with the business side, and vice versa. Well, I have downloaded the files several times now, and they appear to dl just fine. Until I run the setup.exe. Then I get an error "1334" every time. I have seen some forums online about this issue, but none that were helpful. The error tells me that it could be a network problem, or a problem with the package. The package comes in .cab files, and each time I re download the package, a different cab malfunctions. My trainer thinks it could be my security, so I disabled it and re did the download. No good. I worked with tech support til almost 1am last night to no avail. I was informed that if I could not figure out what was wrong with my system, or obtain a different system, my job may be at stake. Can someone help me please??

A:Help! My Job Depends On It!

Can you be more specific as to what virtual machine, where you downloaded from, and what security may be interfering.

Read other 3 answers


Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 5:07:12 PM, on 6/2/2008
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)
Boot mode: Normal

Running processes:
C:\Program Files\Intel\Wireless\Bin\EvtEng.exe
C:\Program Files\Intel\Wireless\Bin\S24EvMon.exe
C:\Program Files\Adobe\Adobe Version Cue CS2\bin\VersionCueCS2.exe
C:\Program Files\Common Files\AOL\TopSpeed\2.0\aoltsmon.exe
C:\Program Files\Common Files\Apple\Mobile Device Support\bin\AppleMobileDeviceService.exe
C:\Program Files\Common Files\AOL\TopSpeed\2.0\aoltpspd.exe
C:\Program Files\TOSHIBA\ConfigFree\CFSvcs.exe
C:\Program Files\Intel\Wireless\Bin\RegSrvc.exe
C:\Progra... Read more

A:Please Please Please. My Life Depends On This!!!!!

Hello 2low2rl and welcome,

One of the infections onboard is interfering with HijackThis. We prefer a more comprehensive set of logs to assist in detecting the extent the malware has infiltrated.

As noted in the final step (Step 5) of our sticky topic IMPORTANT - Read This Before Posting For Malware Removal Help....

Download Deckard's System Scanner (DSS) to your Desktop.

What DSS will do:create a new System Restore point in Windows XP and Vista.
clean your Temporary Files, Downloaded Program Files, and Internet Cache Files, and also empty the Recycle Bin on all drives.
check some important areas of your system and produce a report for your analyst to review.
DSS automatically runs HijackThis for you, but it will also install and place a shortcut to HijackThis on your desktop if you do not already have HijackThis installed.

Note: You must be logged onto an account with administrator privileges.Close all applications and windows.
Double-click on dss.exe to run it, and follow the prompts.
When the scan is complete, two text files will open - main.txt <- this one will be maximized and extra.txt <-this one will be minimized
Copy (Ctrl+A then Ctrl+C) and paste (Ctrl+V) the contents of main.txt in your next reply.
Please attach extra.txt to your post.
To attach a file to a new post, simplyClick the[Manage Attachments] button under Additional Options > Attach Files on the post composition page, and
copy and paste the fol... Read more

Read other 19 answers


"kamsoft-ckvoexe-malware". this is what i got after typing this strange autorun that popped up after i started having restart and hardisk AND GAMING PROBLEMS!
I tried to follow instructions i got on google but now it's seems to have gotten pissed.the symptoms before were as follows-
1-kaspersky failure (so uninstalled it 4 my cousins norton 2k4, huge mistake)
2-oblivion would hang (it later completely stopped working after enough attempts)
3-my hardisk would open on a new window
4-I recently had to remove heavy infections of antivirgear and spysheriff so i think there still traces of the malware duo.
5-error messages just before windows logoff/shutdown.

and the symptoms know are-
1-everything above amplified
2-security programs are always terminated(except bitdefender)
3-WAY faster internet (i actually don't mind that)
4-and last but not least my account is not in administration.

that may have been long but please help me. I have tried everything and i doubt reinstalling windows will be healthy to my comp.PLEASE help


A:Help. Please. My Work Depends On It.

I can't even quarantine it with nod32 and kaspersky. Please help. know i can't even open "D" with explore. please help....Please.

Read other 13 answers

I hope someone will help. I have wasted so much time today.
Someone else used my computer (I know, I know) and got the stupid malware newnet on it. I went and run the "fix" for it which then promptly destroyed all my internet connections and I cannot get them back. I have no idea how to proceed. Going through the IE wizard does nothing. I have DSL, and of course normally just have to click on the IE icon to open Google (or whatever)....now no page comes up no matter what I choose.
I cannot reinstall Windows completely as I have not backed up in a long time and it would take me days to complete that....so that's not an option at this moment. (I have to work on this computer in the morning.) Can someone plllllllease tell me what to do?
Thanks in advance!

A:Need Help DESPERATELY! Job depends on it!

Read other 9 answers

Hi, I am trying to install CitrixReceiver-13.3.2hp1a-all-5.2.x-x86-SQ, but I got a dependency error because firefox is missing. Is this really necessary (I just want to use/update icaclient, not firefox)? And if so, how should I reinstall firefox (I couldn't find any packages for that)? Thanks.

Read other answers

I'm trying to fix IE6 by re-registering Oleaut32.dll and I've read that I need to use regsvr32.exe to do this. I've run it from Start/Run command line but it says it is not a win32 application. Then I read that it needs to be run from a DOS prompt but I am using WinXP (sp2). Also I would like to know how to use a program Depends.exe which shows the dependent modules for dll's. Thankyou

A:Help Using Regsvr32 And Depends.exe Needed

Explanation of Regsvr32 Usage and Error Messageshttp://support.microsoft.com/kb/q249873/ACC2000: Regsvr32.exe Available in Download Centerhttp://support.microsoft.com/kb/q267279/How to use Dependency Walker (depends.exe)http://www.mozilla.org/quality/help/dependency-walker.htmlI hope these links help.

Read other 4 answers

Thank you in advance for any help-

Recently I was working on a document with MS Word 2007 when I suddenly received several save related errors regarding my C drive.

The auto-recovery kicked in and I closed the program and restarted the computer. When I returned to open the document in Word, the file was missing. When I tried to open it from the recently opened files drop down, it said "the file could not be found c:\blah"

From my research and from this link:

I think this issue sounds like the Marker virus- and the date that it happened also seems to be evidence to this fact.
A .tmp file also now has a missing path name which I suspect is the one associated with the file I need.
In addition there is an xml file for what I believe may be my document that remanis however it wont open either- Word says this file is corrupt.
Can anyone offer any solution or ideas on how to recover this document?

thanks so much,

Read other answers

Hi folks. depends.exe will not function on my Vista Ultimate x64. Any program I try to start has an error finding IESHIMS.DLL. The program will not profile as a consequence. There is a search sequence that could be modified but this DLL is not within the list.

Search results as a screenshot is attached. There are about 10 of these DLLs with varying dates, locations and versions. The machine runs very well otherwise; no administrative errors in the logs.

The reason this program is being used was spurred on by a Nero tech who supposedly found an error in the Nero 9 diagnostics CAB file. The complaint was that I could not view an MOV in Showtime. I think it is the file which was downloaded from Frostwire. Nero does everything else perfectly. I would still like to get depends to work for general knowledge and future diagnostics.

I cannot find this problem anywhere on the net or in this forum. Any help would be greatly appreciated.

Read other answers

Ok I have two Disk drives on my computer a Dvd Rom and a Dvd/cd-RW ok
the one drive that is on top is the dvd rom drinve k and the one on the bottom is the Burner ok but when i go to select them in my computer they are out of order it says that the dvd rom is the burner so i can burn my project on a dvd

I put the Blank dvd-r in the drive and it says Not Accesible When i put it on the Dvd/cd-rw drive but the computer labels it as the Dvd rom Drive I realllly need Help I got 5hrs and i need to get this done plz plz pl zpl zpl zpl email me if you can or post here i will try to watch the forums

A:Urgent it Depends on me Passin School

If you are in a hurry, use a flash drive to copy the files . .

Read other 4 answers


I've instaled Win 7 as a second system next to My Vista (both x64). Now I'm emotionally ready to get rid of Vista for number of reasons. Of course Win7 become fully operational and "personalized" system so I don't wont to reinstal Win7...just remove Vista. But my Win7 needs Vista's partition. In magazine I have following description:
"Vista name" D:
healthy (System, Active, Primary)

"Win7 name" C:
healthy (Boot, Pagefile, backup, primary)

How can I move "required stuff" to C: to be able to delete D: partition?


A:Win7 Partition depends on Vista's one

Hello Muzzy, welcome to Seven Forums!

Before we make any specific recommendations will you please post a snip/screen-shot of the entire disk management drive map with a full description as to which drive/partition is which, so we can see what you have going on as there may be a fairly simple way to resolve the situation.

In the Windows start menu right click computer and click manage, in the left pane of the "Computer Management" window that opens click disk management and post a snip of that.

How to Upload and Post a Screenshot and File in Seven Forums

Read other 6 answers

I have windowsXP installed on one HD with one partition d: and i have one addiitional hd with one partition c: . I would like to remove another HD, but windows depends on him, it seems this this is labeled as system, or boot disc? How can i remove non Windows disc and boot only from disc where Windows is?


A:Solved: windows boot depends from another hd

Read other 7 answers

Hi. I searched for information on X-lite and only found two posts, neither one applied to what I need help with. I hope I'm in the right forum for this questions.

I have windows vista 64 bit home professional.

I have to use X-Lite softphone program for my new job. When I try to connect, it says "Failure to connect call". Sometimes I can close the program, other times I have to reboot my computer, but when I hang up on a call, I cannot connect again. Can someone help me please I'm not able to do my job and could loose it if I cannot get this problem solved.

Thank you.

A:X-Lite Softphone Program Help..Job depends on it.

Read other 12 answers

Somebody please help!! I have a very important test which my future depends on on Tuesday.
i have a video that i need to see that a friend gave me which is compressed into 55 .rar files.
but when i try to open it i get this error:

7-Zip 9.07 beta Copyright (c) 1999-2009 Igor Pavlov 2009-08-29

Processing archive: C:\Users\JT\Desktop\Math Tutor DVD\MTDdisc1.part01.rar

Extracting Math.Tutor.DVD.Advanced.Algebra\01.graphs.of.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\02.graphs.of.circles.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\03.transformations.of.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\04.combinations.of.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\05.inverses.of.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\06.quadratic.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\07.zeros.of.polynomials.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\08.complex.zeros.of.polynomials.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\09.graphing.rational.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Adva... Read more

A:Please help me I have a very important test on tuesday which my future depends on!!!!

I don't have 7 zip installed but it appears password protected and the wrong password
is being used.

The person who sent you the file should be able to open it and then resave the files without a password if you continue to have problems.

Read other 2 answers

Somebody please help!! I have a very important test which my future depends on on Tuesday.
i have a video that i need to see that a friend gave me which is compressed into 55 .rar files.
but when i try to open it i get this error:

7-Zip 9.07 beta Copyright (c) 1999-2009 Igor Pavlov 2009-08-29

Processing archive: C:\Users\JT\Desktop\Math Tutor DVD\MTDdisc1.part01.rar

Extracting Math.Tutor.DVD.Advanced.Algebra\01.graphs.of.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\02.graphs.of.circles.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\03.transformations.of.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\04.combinations.of.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\05.inverses.of.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\06.quadratic.functions.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\07.zeros.of.polynomials.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\08.complex.zeros.of.polynomials.avi Data Error in encrypted file. Wrong password?
Extracting Math.Tutor.DVD.Advanced.Algebra\09.graphing.rational.functions.avi Data Error in encrypted file. ... Read more

A:I have a very important test which my future depends on on Tuesday. Please help me!!

we offer no help with pirated software

Read other 1 answers

Can we know the cause of system faillure depends on the type of beep sound when the system is starting up?

A:Can we know the cause of system faillure depends on the type of beep sound..

Yes. Usually there will be an explanation of beep codes in your motherboard manual.

Read other 2 answers

Ok gang, I have one that really is throwing me for a loop. One computer in my company is having difficulties in sending e-mails through Outlook 2007 running POP3. The part that has me scratching my head is that everything works fine while the computer is connected here in our office, but whenever she leaves, she has intermittent sending issues... it just hangs in the ourbox. It works for the first few minutes then stops sending them out. I have searched all through the Microsoft site and couldn't find anything that related.

Any ideas on what to look for?

A:Outlook 2007 - e-mail stuck in outbox (depends on ISP)...

I had a similar issue, though it may not be the same.

Some ISP's (like AT&T, who I hate and despise and upon whom I heap curses and incantations of evil) won't let you use any SMTP server other than theirs to send mail, even if the e-mail account isn't with them. You have to go through a whole rigamaroll to set it up.

But like I said, your issue may be (and probably is) something different. Are there any error messages?

Read other 2 answers


I know this is probably a rather tiresome query, but I've surfed the net endlessly and not found a solution. I'm attempting to populate a memo box, which depends on user choice from a chain of combo boxes (unbound).

I'm creating a classroom planning/assessment database application (the new Learning Essentials for those involved in Australian Education). The system I'm creating, database-wise, is a little complicated (I am an absolute self-taught beginner, so please be kind and precise with your terminology, explaining where I should find the tools you mention). We have 7 "KLAs", which are each chosen with an "Assessable Element" (depending on the KLA) for each grade, which each act as an umbrella for a number of "Knowledge and Understandings" (each K & U has a descriptor of more than 255 characters. Under each "Knowledge and Understanding" is a dozen or so "Detailed Elements" (that the kids get assessed on). So I have the following hierarchy of tables:

Assessable Elements
Year (or Grade in America-speak)
Ways of Working (differing and dependent on previous choices)
Knowledge and Understandings (includes the descriptor)
Detailed Elements

Each table is linked in hierarchy to the one above via foreign keys (and sometimes to more than one table above (my description is the simplified version - it's more complicated than that). So you can imaging that the KLAs table is quite small (only 7 re... Read more

A:Solved: Populating memo box which depends on chain for combo boxes

Read other 16 answers

Hello, I tried turnong it on in services and get an error code 1079. Can anyone help me?

A:The HomeGroup Provider service depends on the Function Discovery Provider Host

Hello kosikfl and Welcome -From Windows 7 forum -I was going to write the directions, but if you scroll down a bit, there is a pictured detail of how to fix this.The HomeGroup Provider service depends on the Function Discovery Provider Host I hope that this is your version of the problem. Thank You -EDITED to correct link -

Read other 1 answers

Hello and thank you for taking time to help me with my computer issue,

I am in no way a computer "smart" person, and will need help step by step, as I am unfamiliar with most terms. Please forgive my ignorance....

Here are my problems...I just got hired (today as a matter of fact, that's why I am freaking out about this) on to a new work-at-home job that will involve using my computer daily starting tomorrow, but have found it to be a MAJOR problem to actually do anything serious on it and need help ASAP.

I just erased 2 virus scanners on my computer and left Malewarebytes' Anti-Malware, so there was no conflict between the 3. I had Windows Defender and Ad-Adware. So the only thing I have left on my computer is Malewarebytes'.

EVERY single time I scan my computer, (I also would get the BSOD when I scanned with the other 2 virus protections as well), whether it be a full system scan or quick scan, I get the "Blue screen of death." It only happens after the scan is complete and is asking me to restart my computer.

I also cannot Google any webpage without it redirecting me to another webpage. No matter what I do, I am constantly being redirected. I use Firefox and sometimes Internet Explorer. Both do the same thing. The only way I can... Read more

A:Need Help ASAP New Job Depends on it!! BSOF, Internet Redirecting, Very Slow Internet

Hi barmardiv,

Please note that these fixes are not instantaneous. Most infections require more than one round to properly eradicate.

Please stay with me until given the 'all clear' even if symptoms seemingly abate.

Kindly follow my instructions and please do no fixing on your own or running of scanners unless requested by a helper.


Let's start with Combofix.

1. Download ComboFix from one of these locations:

Link 1
Link 2

* IMPORTANT !!! Place combofix.exe on your Desktop
2. Disable your AntiVirus and AntiSpyware applications, usually via a right click on the System Tray icon. They may otherwise interfere with ComboFix.
You can get help on disabling your protection programs here

3. Double click on combofix.exe & follow the prompts.
Note: Windows Vista users will have to right-click on the file and select "Run as Administrator"

4. As part of it's process, ComboFix will check to see if the Microsoft Windows Recovery Console is installed.

Please note: If the Microsoft Windows Recovery Console is already installed, ComboFix will continue it's malware removal procedures.

The Windows recovery console will allow you to boot up into a special recovery mode that allows us to help you in the case that your computer has a problem after an attempted removal of malware.

With malware infections being as they are today, it's strongly ... Read more

Read other 19 answers

I am running Microsoft Office Professional Plus 2010 on Windows 7.

When I open Excel my personal.xlsb opens fine and my macros are available and I can create new macros. No problems.

BUT when I open any existing Excel file the pesronal.xlsb is not opened and therefore no macros and I cannot create new macros as I get the error "Personal Macro Workbook in the startup folder must stay open for recording." I have been trying things all night with no luck. Any suggestions would be greatly appreciated. I will list the things I have tried or checked with no success below:
In Options>Advanced Tab>General Section....the box for "Ignore other applications that use DDE" is NOT checked.
In Options>Trust Center>Trust Center Settings>Trusted Locations... I have C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART listed which is where my personal.xlsb is located
In Options>Trust Center>Trust Center Settings>Macro Settings ...Disable all macros with notification...selected and not selected neither way solves the issue.
In Options>Add-Ins>Manage: Disabled Items ...There are no disabled items.
I have deleted HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel in the registry editor
I have deleted C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB and then run excel to create a new personal file.
I have renamed C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB to PERSONAL.XLSA

Thank you in advance fo... Read more

A:PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

Read other 6 answers

Hi! i need you help!.. I am unable to open or save files in the shared drive using Excel 2007 but i can open/save excel 2007 files saved in my local drive

The error message I get when i try to open is "Could not open...." followed by the path and excel name.

This is the error message i get when i try to save in the shared drive:

Microsoft office excel cannot acces the file". There are several possible reasons:

the file name or path does not exist
the file is being used by another program
the workbook you are trying to save has the same name as a currently open workbook

Please help

A:Unable to Open and Save Excel files in the shared drive using Excel 2007

Read other 15 answers

Running Windows Vista Premium Home Edition.

I have an Excel 2003 spreadsheet.that I originally created on Excel Office Professional Edition 2003. Also, have Excel 2007 Home and Student Edition installed. I uninstalled the Excel 2003 software, but now when I clik on this created Excel 2003 spreadsheet with Excel 2003 it will not open. It says there is an invalid path. I reinstalled Excel 2003 and it opens. I tried to save this as an .xlsx extension and then uninstalled Excel 2003. It wouldn't open. So something is occurring here. On other Excel 2003 created spreadsheets, they open without issue.

Then I have a program with an .exe extension. It needs to open using Excel 2007. With both Excel 2003 and Excel 2007, it will not open. It freezes and then I get an error message saying it cannot open with another Excel other than 2007. If I right clik on the .exe program, there is no "Open with". I even tried opening a blank Excel 2007 spreadsheet and then cliking on "Open". but it is a bunch of gibberish. My IT person says you can't open the program that way, You have to launch it as an .exe program using Excel 2007.

Any ideas on what is going on? By the way, I have both Excel versions on my laptop running Windows XP and I do not have these issues at all.

A:Solved: Some Excel 2003 & Excel 2007 applications won't open on Windows Vista

Hi there,

If I said I was confused that'd be an understatement I think. You cannot open executable files (*.exe) with Excel. Recognized file types are things like .xls, .xla, (for 2007) .xlsx, .xlsb, .xlsm, etc. I don't know what your exe file is and I'm not sure I wanna know, but it certainly doesn't open in Excel. What is it exactly? If you don't know I wouldn't open it. Or if someone told you to open it with Excel then it's probably a virus. Unless I'm missing something here.

With the file in question which won't open, assuming it's not this strange and unknown exe file you're talking about, sounds like the file may have been corrupted. Does it open on any other machine? And if you uninstall Excel 2003, did you re-install 2007? It seems strange. I would try cleaning out your application and reinstalling 2007 fresh. You can't install 2003, then 2007, then take off 2003 and put it back on, you're gonna get things screwed up. I bet your registry doesn't know which way to turn here. Some good info on it can be found here...


Also, I would highly recommend you completely uninstall all versions, and I'm talking a deep cleaning, then reinstall. For that deep cleaning, take a look at this article (which I'd highly recommend you do) and then reinstall...

http://officearticles.com/misc/remove_microsoft_office_from_your_pc... Read more

Read other 2 answers

I transferred all my old Excel (2003 and before) files to my new notebook which has Vista HP and Excel 2007. I open an old Excel file and it looks OK but when printing or print previewing, every line appears double-spaced and the document runs over to a second page.
If I change the row height it prints the squeezed up text but still double-spaces. If I copy the whole content of the spreadsheet into a new blank spreadsheet it prints normally.
Is there any setting in Excel 2007 that I might have missed ?

A:Printing Excel 2003 files with Excel 2007 give double spacing

Read other 7 answers


I've recently had to get a new computer and decided to try a Mac. Everything works fine, however, I have excel files which I have transferred from my old Windows laptop which, when opened on the Mac, have not kept the colour formatting from the windows version. Is there anything I can try to see if the original colour formatting can be accessed or will I have to re-colour them all from the start?

Thanks for any help, advice, support in advance.


A:Excel 2003 (Windows) to Excel 2011 (Mac) colour format issue

Hi Wayne, It's not the MAC, the issue is the fact that the newer versions of Office (also on MACS) have diffrente shading of colors.
The basic colors in Excel 2003 are not always the same.
I imagine that there is color formatting but that the shades are off, correct?

I think it will have to be hand-work, I don't know hoe Microsoft thinks about this but, well, compatability is an issue here

Maybe there's a setting somewhere that tells it to use the standaard (old version) settings, but I doubt that.

You'll need an inside-out Microsoft expert for this, I think.

Read other 1 answers

I am trying to create a code that will autofilter data on an Excel worksheet. The code works fine to filter the data, but it does not hide the AutoFilter Arrows.

Below is the code I am using. What (if anything) is wrong with the code below?

ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>", Visibledropdown:=False

A:Solved: Excel 2007 Macro -> Hide Excel AutoFilter Arrows

I noticed that the code above (in Post #1) that the AutoFilter Arrows were beinf truned off on Field 2, but none of the others.

I have played around, and done some research to come up with the code below:

Dim c As Range

For Each c In ActiveSheet.Range("A1:D1")
ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>"
c.AutoFilter Field:=c.Column, Visibledropdown:=False

Does anyone have a better solution?

Read other 1 answers

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help

A:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

Read other 6 answers

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you

A:Solved: Excel macro to extract Word form data into Excel

Read other 7 answers

I have a friend who is suddenly experiencing an issue where they are no longer able to Open an Excel file through their Windows Explorer (e.g. when trying to open a Excel file from within their My Documents folder). After double clicking on the file, Excel opens and acts as if it is opening the file but then proceeds to show just a blank worksheet. The file does not appear to be corrupt since they can then go to File/Open from within Excel, locate the folder and then Open it without a problem.

Any suggestions? Any ideas would be greatly appreciated as to the cause and resolution for this.

Thank you greatly,


A:Excel 2000 - Unable to open Excel file thru Windows Explorer

Check this out: http://www.pcreview.co.uk/forums/thread-1781119.php

Read other 1 answers

FONT=&quot;Tahoma&quot;]Hi All,Sorry for the long post!I use Office 2007 and I use an excel based tracker with 7-8 worksheets. There are macros, pivots, formulas & tables used in the workbook. Yesterday, I was writing a macro to extract few rows from 1 sheet based on a cell value in another sheet. paste the extracted records into a temp sheet, format them ( delete extra columns, rearrange order etc), then paste into a table which has few more columns with formulas to fetch related data from other sheets for these rows. My development was complete and it was all working fine, but the excel was taking too long to save - probably beacuse the new table i added. I added it to the complete worksheet with only the columns i needed - all rows in the work sheet are part of my table. I closed the sheet and now it doesn't opens.After trying to open the excel for almost a minute, I get a message - Excel found unreadable content in 'xxxxxx.xlsm'. Do you want to recover content of this book? If you trust the source of this workbook, click yes.When I click yes, it attempts to open the sheet, but then it says - &quot;Excel cannot complete this task with available resources. Choose less data or close other applications.&quot;I tried, closing all applications, restating my machine, opening the excel in safe mode, but it is not happening. Please help me!Thanks,Mrinal

A:Excel found unreadable content in 'xxxxxx.xlsm' - Excel 2007

Hi, welcome to the forum.
This happens when the VBA code has a serious fault or simply the file cannot be saved correctly.
I generally open a previous backup file. Not the one Excel creates but a latest working version which I always store in another folder, just in case.
As of excel 2007 the file is really a self extracting zip file.
If you add . zip to the file nme: yourfilename.xlsm and then make it yourfilename.xlsm.zip and open it with winzip you can see all the part of the file and try and remove the section named vbaProjec.bin
You will loose your VBA modules but the file can be opened after you coles the archive and remove the .zip

Read other 1 answers

Iím using Windows 7 and I used a macro which worked totally fine under Excel 2003. Now, under Excel 2007 it does not run anymore but displays the following error message:

"Run-time error '445':
Object doesn't support this action.

The function of the macro is to open up all other Excel spreadsheets located in the same folder and copy data out of them into the spreadsheet in which the macro is stored.

When I click on "Debug" the Visual Basic Editor highlights the row which says: Set FilSrch = Application.FileSearch

Can you help me with this? I've searched for a solution for a long time but could not find anything which worked.

The following is the start of the macro code:

Sub UpdateTable()
Dim X As Range, I As Integer, J As Integer, RecNo As Integer, CopyVal As Variant
Dim SourceBk As Worksheet, DestBk As Worksheet, StartRow As Integer, IndRange As Range
Dim ServRange As Range, SrcOpen As Boolean, SourceName As String
Dim FilSrch As Object, MyFilArray() As String

'MsgBox "This function not available in this version.", vbInformation, "Function Not Available"
'Exit Sub
'Sheets("LookUp").[a12] = Now
With Application
.ScreenUpdating = False
.StatusBar = "Counting source files ..."
End With
Set FilSrch = Application.FileSearch
With FilSrch
.LookIn = ActiveWorkbook.Path
.FileType = msoFileTypeExcelWorkbooks
If .Execute > 0 Then
ReDim MyFilArray(.FoundFiles.Count)
For I = 1 ... Read more

A:Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested

Read other 7 answers

To begin with, I just want to check if this is viable, and if so, which solution is best/easiest...

Office 2010.

Current situation:
An Outlook rule moves certain messages to an Outlook folder.
A macro button is used to run code that prints the attachments of all messages in that folder.
Think it then deletes the messages.

Required situation:
Instead of printing all attatchments, the macro needs to look at a specific column of data in an Excel file.
If a value in the Excel column matches (or part matches) the filename of the attachment, the attachment is printed.
All attachments with filenames that do not match the Excel list are left alone.

Alternatively, switch it round, so the macro is in the Excel file, and it checks the values in the column against the attachment filenames of messages in that Outlook directory, and prints those that match.

Alternatively, write something in Outlook code, perhaps using a form control, whereby the user can enter (paste in) the batch of values, and it then prints attachments accordingly, rather than trying to forge a link between Excel and Outlook.

Alternatively... use some 3rd party tool that accepts the batch of values and interacts with Outlook to print the attachments, bypassing the need to write and manage code.

Or something else?


A:Outlook/Excel - Print selected attachments based on Excel list

Alternatively... modify the existing Outlook macro to save all attachments to a dir on the PC instead of print, and then write an Excel macro to check the files in the dir instead of the Outlook folder.

Read other 1 answers

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.

A:Solved: Excel 2010 v Excel 2003 Error Valid Range

Read other 14 answers

Ok this is a weird problem I ran into in the past with Word, and I'm having trouble finding information on it, because of the details involved.

What's happening is if i load up Excel and then goto file/open and load an excel document it comes up.

If I goto Start/Documents and try to load it from there Excel seems to hang, also if i Browse my computer and goto any excel file same thing happens, and of course it happens over a network share as well.

I didn't give it more then a minute or 2 to come up (We are talking small Excel files here nothing huge) On the last computer this happened on with Word, the documents would eventually come up, but it would take 5 minutes to load this way.

Anything I load withen Excel (Meaning I load excel and then goto File/Open, comes up instantly)

Windows knows how to handle the excel files and what program to load them with, I tried deleteing the (Is it called a mime?) entry in windows that tells excel how to handle the .XLS file, then held shift and Right clicked a .XLS file to re-enter it into Windows, just in case Windows wasn't opening it right but this had the same effect.
Any ideas?

A:Can't open excel files by double clicking, HAS to load withen excel

Read other 9 answers

I am trying to open a spreadsheet that was created in Excel 97 using Excel 2000. The links and macros that are on the sheet seem to prevent it from opening. There are a load of error messages but I just cannot get the thing open. I have searched so many places, found the same problem but no answer.

Can anyone help?


A:Excel 2000 problem when opening Excel 97 spreadsheet with links and macros

Welcome to TSG.
Can this file be opened fine in Excel 97? Any chance that it is corrupted?
What are some of the error messages you are getting?


Read other 3 answers


I was wondering if anyone could help me. I need to extract data from multiple excel files into a new excel file and sum the values. The data comes from excel files that are made from a template so the data is always in the same place or same cells. For example, i have data saved daily in excel files with the following naming convention 080204, 080304, 080404,..... and so on. What i would like to do is have a macro that will create a week ending sheet by importing and summing the data from that week.

Thanks for reading!

A:excel macro for copying and pasting data from multiple excel files

thanks for all those who read!!!! let me know if anyone needs the code!

Read other 1 answers

Problem in Excel 2010 [but revives a Closed TSG thread for Excel 2007]

The "Personal Macro Workbook" is a file called Personal.XLSB
The Personal.XLSB file is in the correct location /XLSTART/
The file properties option "Opens with Excel" is selected.
The file contains a (freshly re-made) macro.
(It also contained the same steps macro before it was deleted
and re-recorded during troubleshooting for this problem.)

When Excel is opened, the Personal.XLSB DOES NOT OPEN WITH it.

Because the Personal Macro Workbook does not open,
- existing macros do not function,
- nor can new macros be recorded

Same not-opening result, whether opened by clicking on
- Excel, in the Programs list or
- a desktop shortcut to a specific Excel file

However, the Personal.XLSB file can be opened and the macro made functional
by manually opening that file where it is stored in /XLSTART/

An unexplained workaround was identified in the closed thread.

*rename the Personal.XLSB to Personal.XLSA

I find this workaround effective.
The Personal.XLSA file opens with Excel and the macros are available.
But the file seems to be grayed out when viewed with Explorer in /XLSTART/

However, I do not like using workarounds, as they can cause trouble later.
I find that the "open with" setting was changed when the extension was changed
The setting is now "Opens with: Windows Shell Common"

I would appreciate an explanation how to make Personal.XLSB open as it should.
... Read more

A:Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

Read other 16 answers


I need help to create an Excel macro that would

1. ask users to select x number of rows to be copied from one worksheet of one Excel file
2. once users have selected the rows to be copied, then the rows are copied from the one original Excel file into X number of target Excel files

the target Excel files are all based on the same template
there is one worksheet in each of the target Excel files

in the target files, the rows should be copied from the first available empty row, going down

Looking forward to your help!

Thanks a lot.

A:Macro needed to copy x number of rows from one Excel file into a batch of Excel files

Hi, welcome to the board.
Not much info there to get the correct picture.
Sample? Of source and template please
And not to forget, what version of Excel are you and the users using?

Read other 1 answers

I have just been upgraded to Excel 2007. I find that some of the macros that were recorded in Excel 2003 no longer work in Excel 2007. We use the Analysis Toolpak VBA add-in and I have added this in to 2007 ok, but when running a macro I get a run time 1004 error ATPVBAEN.XLA cannot be found. After some searching it would appear that some of these functions have been renamed in 2007 e.g. it is now a .XLAM file rather than .XLA which is why the macro code can't find it. I guess I could manually edit all the macros and change the fucntion names but there are other colleagues in my team that are still using 2003, so I don't want to break things for them. Is there any solution to this? Thanks

A:Solved: Problem with Excel 2003 macros in Excel 2007

Read other 8 answers

I have an Excel Workbook where I try to embed a Word and Excel file (icon). But, I cannot open the file afterwards. However, my colleagues can open it when I sent it to them by email. What could be the problem with my application.

I tried disabling my spyware software and reloading Microsoft Office XP but the problem is still there,

What could be the problem?
Thanks a lot

Read other answers

Firstly I am a beginner of beginners but I try to learn as much as I can.
I have put the following protection code into an Excel 2003 workbook and everything runs ok. I then opened the workbook in Excel 2007, and saved it as a .xlsm file. When I try to open the .xlsm file in Excel 2007, I get a vba Runtime error 13, "Type mismatch", and the code sticks at the first line below("If Worksheets...). I have tried everything that my limited knowledge allows, searched the web for 2 days, and still have no answers.
Any help would be greatly appreciated.

Private Sub Workbook_Open()
If Worksheets(28).[A51] > "" And Worksheets(28).[A50] = Worksheets(28).[A51] = False Then
MsgBox "Sorry, this program is not registered for this computer, please e-mail .......... for more info."
Application.DisplayAlerts = False
End If
End Sub
My system specs are shown below.

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i3 CPU M 380 @ 2.53GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2934 Mb
Graphics Card: Intel(R) HD Graphics, 1243 Mb
Hard Drives: C: Total - 290143 MB, Free - 172186 MB;
Motherboard: Dell Inc., 0WXY9J
Antivirus: avast! Antivirus, Updated and Enabled

A:Solved: Excel 2003 vba code not working in Excel 2007

Read other 16 answers

I am using an ASP.NET 2.0 web application using the Interop assembly pointing to the Microsoft.Excel 12.0 COM to open and write to a spreadsheet.

I have set the permissions for the DCOM to allow NETWORK SERVICE to open the Excel application, but when I try to open the actual file I get Exception from HRESULT: 0x800A03EC.

I have changed the website directory permissions to allow NETWORK SERVICE full access to the folder and I still cannot open the file.


Read other answers

I want to merge two excel files into a 3rd one.

The data are in the files Book1, Book2 and the result in Book3.

I know that i can use VLookup to do the above. But what i have pasted is just an example. The real excel files contains about 9 columns with at many repeating row!!!

Any help will be much appreciated.

A:Excel - macro to merge 2 excel files using a common column

Hi welcome to the board. How are you going to treat the duble items, If you want to merge 2 files adn duplication occurs here must be one cell whihc is common to let's say Book1 and Book2.

Do you have a common value? Index? Whatever you call it?

Read other 3 answers

I'm working on a Bill of Material creation automation project that requires some expertise in VBA, and I have none.
The objective is to run a macro from an excel spreadsheet called "PGE BOM", to do the following:
1) Go to the folder "C:\Documents and Settings\Desktop\Auto Project"
2) Find all the .mdb databases in this folder
3) Find "HistoricalMaterialItemsAll" table in EACH of those databases in step 2, and import the data from the columns listed below into PGE BOM.xls's columns C through G:
The following is a VBA code that my friend had written in Excel 2007. Unfortunately I have an older version (2000) and the code does not seem to be compatible with Excel 2000.
Sub ImportAccessData()
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
sRow = 2
bFile = False
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath)
strFlNm = Dir
If strFlNm = "" Then bFile = False
End Sub
Sub GetData(fl)
strSQL = "Select HistoricalMaterialItemsAll.* From HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, xlCmdTable
Set WB = Application.ActiveWorkbook
Set WS = Applicatio... Read more

A:Excel Macro - VBA code to import access data to excel

Hello, and welcome to the board!

When posting code, please use CODE tags, which extremely helps with readability.

Perhaps you could try using the code constant???...

Option Explicit

Sub ImportAccessData()
Dim dPath As String, sFile As String, strSrch As String
Dim TargetWB As Workbook, TargetWS As Worksheet
Dim sRow As Long, bFile As Boolean, strFlNm As String, strPath As String
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
sRow = 2
bFile = False
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath, TargetWB, TargetWS)
strFlNm = Dir()
If strFlNm = "" Then bFile = False
End Sub

Sub GetData(fl As String, WB As Workbook, ws As Worksheet)
Dim strSQL As String, iRow As Long, sRow As Long
strSQL = "SELECT HistoricalMaterialItemsAll.* FROM HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, 3 'xlCmdTable
iRow = 2
Do Until ws.Cells(iRow, 1) = ""
ws.Cells(sRow, 7) = ws.Cells(iRow, 5) 'Get the Description
iRow = iRow + 1
sRow = sRow + 1
Application.DisplayAlerts = False
WB.... Read more

Read other 1 answers

Most of my Excel files open fine with a doubleclick from Windows Explorer. I have two XLSX files however, that "try" to open when I single click. They open to a blank, grey screen - essentially they open Excel, but the file does not open. (I do see a quick flash of tabs at the bottom indicating the file is starting to open or opens and then terminates immediately).

The problem is clearly not a "tiled window" or "window offscreen" problem - there is no file open. All the Excel functions are greyed out. If I go to File-->Options, i just get a blank grey screen. If I go to file --> open, I can then open any file.

It seems that these two files have some kind of trigger property that starts Excel with one-click, but I can't find how to change that property. None of my other XLSX files act this way.

UPDATE: Further experimentation reveals that this problem is somehow linked to password protection. I copied all the tabs to a new sheet and saved as XLSX. This sheet works normally, i.e. I can click on it once to highlight it and it does not open Excel. I double click and it opens. But once I password protect it, the behaviour changes to that described above.

A:Excel 2010 - Excel Opens Blank on One Click of File

Do you have the "preview pane" on? if so, turn it off and you should be able to view the password protected documents properly.

Read other 1 answers

i have windows 7 32 bit and ms office 2007!i have a excel file named work.xlsx located in (d:\andi\),andi is my folder and the final path is (d:\andi\work.xlsx).i create a new folder in d:\ named (andi2) and i copy of excel file (d:\andi\work.xlsx) in (d:\andi2\work.xlsx).now i have two identical copies of (work.xlsx) in two different paths.Now i want to send a shortcut of (work.xlsx) in desktop,but i want to modify excel file shortcut that is located in desktop and the changes that i made in shortcut will be reflected in both (d:\andi\work.xlsx) and (d:\andi2\work.xlsx).ONE EXCEL FILE SHORTCUT MODIFY AT THE SAME TIME TWO EXCEL FILES!!! thanks a lot if you help me!

A:One excel file shortcut modify at the same time two excel files!!!

so just so's I understand; you want one shortcut to open two files? That ain't going to work.

Read other 1 answers