Free Microsoft Excel 2013 Quick Reference

excel virus?

I'm having this problem where my formulas won't drag into other cells. Well, the formula drags, but it drags the value from the original cell along with it. If I click on the formula icon to get the formula box, it shows the correct value in the "result" section of the box. However, the cell itself will only show the value from the original cell.

So, to get the dragged formula to show the right value, I have to click in the
formula bar so that the referenced cells are highlighted, and then hit enter. It's like I'm having to "activate" the formula or something.

Is it my settings? I've rebooted, so it's not that.

Thanks for looking.


Post your answer or comment

comments powered by Disqus
A colleague of mine seems to have an Excel virus that corrupts a worksheet
and changes standard Excel column header settings from letters to numbers.
Once this worksheet is opened it seems to trigger a default through-out Excel
so that when-ever another worksheet is opened the column header settings
always show as numbers instead of letters.

Does anyone know of this virus and is there a way to solve it?

I have a very large file with several worksheets. It seems I have something weird going on. Excel has resorted some of the columns and now they're out of order. It has shifted columns on many of the worksheets also. Is it corrupted? Could it be a virus? I tried to "open and repair" with no effect.

Hi Gang,

My copy of Excel may have a virus or something. However, AVG
Anti-Virus says the document I'm having problems with is A-Okay.
Basically if I work with a new sheet I can minimize, maximize, and
restore the child window like one would expect. However once I open my
EPS timesheet, which I've been using without issues for months now
opens at a size to small to manipulate and in a window lacking border
controls to resize. Please see the screenshot to see what I'm talking
about. Does anyone know if there's a properties dialog or a repair
feature that can fix this document, since that's the only one that's
affected. Also I may be suffering from some as of yet unknown Excel
virus.

Here's a screenshot as you can see there are no controls on the child
window
http://www.rawseattle.org/~christian..._Are_Hosed.png

Thanks for any help regarding this matter,
Christian Blackburn

How do I stop the virus scans every time I open an exel file?? It wastes a
lot of time

Hi,

Ive got a spreadsheet that is essentially calculation based, reporting on a live view of a database. I have a small bit of code in it that allows an offline snapshot copy of itself to be saved so that it can be distributed.

The problem I have is that I want to remove the code from this snapshot to prevent it triggering Excels virus protection. In itself that's not a problem, the difficulty I have is that unless the reference to the VBIDE is removed it still triggers the virus protection.

In itself, the code to remove the reference works fine, but when it is combined witht the code that removes itself I get a compile error.

Any ideas?.


	VB:
	
) 
     'Sub triggered by the Before Close event that removes the command button and
     'removes the code if saving as output file
    Call RemoveCommandBtn 
    If RemoveMyCode = True Then 
        Call RemoveCode(ThisWorkbook.VBProject.Name) 
        Call DeleteRefLibraryVBIDE 
    End If 
End Sub 
 
Private Sub RemoveCode(ProjectName As String) 
     'Sub that parses through all the loaded code modules and removes them if they
     'are in the Report V.xls workbook
    Dim Project As VBProject 
    Dim Component As VBComponent 
    Dim CodeWindow As Variant 
    Dim line As Integer 
    Dim linecount As Integer 
    For Each Project In Application.VBE.VBProjects 
        If Project.Name = ProjectName Then 
            For Each Component In Project.VBComponents 
                If Not Component.CodeModule.CountOfLines = 0 Then 
                    Let linecount = Component.CodeModule.CountOfLines 
                    For line = 1 To linecount 
                        Component.CodeModule.DeleteLines (1) 
                    Next 
                    If Not Component.Type = vbext_ct_Document Then 'this is superfluious now as all the code is in the
'ThisWorkbook' Module
                        Project.VBComponents.Remove Project.VBComponents(Component.Name) 
                    End If 
                End If 
            Next 
        End If 
    Next 
End Sub 
 
Sub DeleteRefLibraryVBIDE() 
     'Deletes the reference to the VBIDE
    On Error Resume Next 
    With ThisWorkbook.VBProject.References 
        .Remove .Item("VBIDE") 
    End With 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


my excel files being modified by a virus (worm_blueworm) to become only 78
bytes and contains message "has been expired please contact Mr. Bill Gates
for the acitve now, Thanks you.". Can anyone help me how to recover the files
...??? million thanks.

I use and amend Excel files on my PC. 99.9% of the time they do not need a
virus scan so it is a waste of time "Requesting a virus scan" every time I
open a file. How do I turn it off as a default, and how do I turn it on for
the once in a blue moon accasion I need it?

I am running Microsoft Excel 2007 (Office 2007 Business) with XP Pro

When I open an Excel 2007 workbook....the bottom left indicates.........
"Running Virus Scan"
This results in the Workbook taking a long time to open.

I located this KB Bulletin
http://support.microsoft.com/kb/919047
This bulletin refers to Word 2007

Method 1
Suggests I remove the program that installed the addin.....that I assume
would be the Office Small Business Installation!!! but I want that.

Method 2
Suggests I remove the .wll file (which is probably a Word 2007 file
extension) from the startup folder.
With Folder Options: View Hidden files unchecked.
I have located the folders but they appear to be empty.

Questions
1. How can I stop this annoying virus Scan?
2. Is it a regisrty setting?

Thanks in advance

When I open my file in excel it continues to say running virus scan for hours
and overnite. How do I stop this so I can use this file?

When I install add-ins (such as the XY Chart Labeler, Power Utility Pack),
Excel goes through a series of "requested virus scans" each time I start-up
Excel. This is not usually a problem but it creates an uncomfortable pause
when Excel is launched from a hyperlink in PowerPoint.

Is there a way to turn off these unnecessary virus scans?

I want to prevent virus scans when I load an existing Excel file. Cannot
find solution in excel help.

every time i open up a file for the first time in excel it starts the norton
anti-virus (as expected) then comes up with a message norton anti-virus does
not support re-intalling please uninstall and then re-install anti-virus
program!

my excel files being modified by a virus (worm_blueworm) to become only 78
bytes and contains message "has been expired please contact Mr. Bill Gates
for the acitve now, Thanks you.". Can anyone help me how to recover the files
...??? million thanks.

Dear alls,

I have some file has Virus Excel 4.0 Macro. They disturb me so much.
Please help to show me the way kill them.

Thanks in advance

OverAC

Warning! my virus scanner (Avast) is going wild reporting javascript trojans if I click on the "Home" tab or the Excel Tips tab!

I use and amend Excel files on my PC. 99.9% of the time they do not need a
virus scan so it is a waste of time "Requesting a virus scan" every time I
open a file. How do I turn it off as a default, and how do I turn it on for
the once in a blue moon accasion I need it?

How do I kill "requesting a virus scan" as I open any Excel XP file? I have
macro Security set to low and am using Norton Anti-Virus 2005 along with
three anti-spyware tools but Excel insists on "requesting a virus scan".
How to kill that request?

--
....guarded by a tired Cohort of Roman Heavy Infantry"

I have a program in Excel with VBA code. The VBA code is all under password protection.

Is it possible for Excel to carry a virus or worm or whatever to another user?

If it can, how does a virus get into the Workbook?

If it can, how do I protect the program from carrying a virus?

I have never heard of this happening, but I want to be sure.

When I install add-ins (such as the XY Chart Labeler, Power Utility Pack),
Excel goes through a series of "requested virus scans" each time I start-up
Excel. This is not usually a problem but it creates an uncomfortable pause
when Excel is launched from a hyperlink in PowerPoint.

Is there a way to turn off these unnecessary virus scans?

I have a worksheet with a button control that is linked to a pdf file found out on the web. This is working fine at this point with one exception. Every time you click on the button Excel puts up a message box stating the following:

“Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source.

Would you like to open this file?”

Is there a way to disable this in excel?

Thanks,

CJ

I work as technical support for a school system -

I have had a few users call in saying that on their excel workbook the sheet tabs are gone--
Believe me - I have checked everything-----

I have it set to display sheet tabs
when she starts a new workbook the tabs appear in the new file-
Sometimes when she gets to the old file the tabs will reappear after she has created a new blank file--sometimes they never reappear

I have checked machine for viruses

I have fixes to get around the problem
but does anyone know why this happens?

Many thanks

I'm attempting to help a colleague. Apologies in advance for making this complicated. He has a spreadsheet, which is linked to another spreadsheet, which in turn is linked to the company's internal accounting package, so it's Accounting Package -> Spreadsheet #1 - > Spreadsheet #2. Both of the spreadsheets contain macros. The problem is that he is trying to link figures in Spreadsheet #2 to a Word document. He has made the links using the Paste Link function but everytime he opens the Word document to update, it asks to update the links and does it one by one, technically trying to open Excel 28 times. I have had him change all the links to Manual, so he could use the Edit/Update Links button by selecting all the links, and only have to do that once, but it's still trying to open Excel 28 times and giving the Macro Virus warning message each time as well, so he's having to press Yes 56 times instead of 28. Is there another way to paste the links or have the update accept all the macros automatically? Deleting the macros is not an option. Sorry for being so long-winded, but the goal is to have Excel open only once, have the macro warning only come up once and have the links update automatically as they should.
Many thanks for you help.
Cheers!
Deirdre

I am wondering if anyone has had a similar event take place to them while using Excel 2002 on Windows ME? This weird behavior occurs when I am in the midst of editting a worksheet, I highlight a group of rows and columns, and then all of a sudden the highlighted area changes shape just before I am able to complete the action that I intended to do. At first occurence, about 4 months ago, I thought it was a virus of some sort. I reformatted my C-drive and loaded a fresh copy of Office. It still occurs and it's a bit annoying. Any thoughts? Thanks in advance....

I have just finished compiling a fairly complex spreadsheet at work only to find out that most of the companys computers are infected with the Office 97 Tristate virus.
This is a real pain in the butt because our system support department dont see it as a big problem and have recommended they take no action to fix it!!!
My problem is that my spreadsheet wont function properly due to the crap this virus puts into my code.

This is a bit beyond me... but for the Excel/VBA gurus out there.... is there a way I can protect my code from infection from this virus under an Office 97 environment???
I am at my wits end....please help if you can....


No luck finding an answer? You could always try Google.