Search results for query: *

Pulling my hair out! Windows region settings are English UK with short and long dates as day month year. The cell format is DD-MM-YY HH:MM:SS If I click on the time at the bottom right of my desktop the calender that comes up shows 1 December. So windows knows the correct date. I am using...

I am using excel 2010 (and I have PowerQuery installed but not used in this workbook). The source data is a table in another workbook. The message I get is "Too few parameters. Expected 3." Why would it expect 3? How do I best resolve this, please? The SQL is: SELECT...

I am constructing a mail merge using Word 2010 to construct an (HTML) email. The mail includes a table containing merged fields. How can I format the numbers to 2 decimal places and with thousands separators? Can Word do this or must I change numbers to formatted text in my source table. In...

I have a single linked workbook. When I use Data=>EditLinks=>ChangeSource only some of the links in my workbook change. Data=>EditLinks then shows two sourcefiles I can use Edit Replace to successfully change the links. I have posted here because the problem occurs in Excel. However this is...

When this code gets to the Workbooks.open line I get runtime 1004 "The password you supplied is not correct....." And if I test in the immediate window DisplayAlerts has been reset to True. I must be making a silly error but can't work out what :( For Each c In rPasswordList On...

Function PivotRefreshDate(CellWithinPivot As Range) PivotRefreshDate = CellWithinPivot.PivotTable.RefreshDate End FunctionManually opening the workbook and refreshing the pivot causes the UDF to update correctly. However using this code the UDF returns an error (it does not halt, the cell just...

in the Immediate window I enter: userform1.show vbmodeless and the userform is displayed complete with its label, as expected. On the other hand when I have the same command in my procedure the Userform displays but the label is not visible. If I watch the expression userform1.Visible the...

Is this a limitation of the index function, a problem with a compatibility setting or a workbook corruption? This formula in cell 65536 works =INDEX(CC_Hierarchy_C_ALL.xls!CC_Look,$A65536,C$1) However if I copy it to the next row it becomes =INDEX(CC_Hierarchy_C_ALL.xls!CC_Look,#REF!,C$1)...

I have noticed that I am getting an increased number of corrupt excel files. "Excel found unreadable content in 'xxxx.xlsm' Do you want to recover......" Sometimes Excel can recover most of the info but other times it can't. It could be coincidence but it seems to me that this is since I...

I want to open a file but it could be either a real excel workbook or a tab-delimited text file with .xls extension. If it is a text file then I want to use the OpenText method. So how can I test? Another approach to the issue would be to change the default parameters that Excel uses when...

In xp I could view my offline files. This gave me one big list and one column showed me the status of each file. I could sort by this column and see which files had not synced and synchronize those in priority order. Now I am using Windows 7 and I have not found a way of doing this. The...

I want to manipulate the existing text in a column but my existing code takes much too long to run Sub test() Dim myRange As Range Dim c As Range Set myRange = Selection For Each c In myRange Select Case Right(c.Value, 4) Case strCurrentYear 'Current...

Error Message: Run-time error '1004': Unable to set the Hidden property of the Range task The above error is confusing me. The code concerned is: With ThisWorkbook.Worksheets("CreateLog").Range("Progress") [highlight red] .Calculate[/highlight] .Offset(.Value, 1) = Round((Timer -...

I am puzzled over this error! The line of code is: If Application.Calculation = xlCalculationManual Then myRange.Calculate At this point myRange.address = "$F$8:$F$1962" The error is Runtime error '1004' Calculate method of Range class failed Gavin

On my laptop I installed Win8 Release Preview onto my new SSD drive without disabling the original hard drive. When I boot up I get a choice of operating system. This is great and I would like to get the same thing on my desktop. When I installed Win 8 on my desktop I first disabled the main...

I want to create a named range the bottom right corner of which is the bottom right cell of the pivot table. CAn anyone help with how to find the last cell. The following only works if I first reset the last cell in the workbook and second if there is nothing else in the workbook. With...

I have a large Excel Table. I am working in xl2007 but solution must work in 2003. I want to identify the records where a "document_number" relates to more than one "Service". My current formula is based on sumproduct which, with 60,000 rows, not suprisingly takes too long. Is there a better...

Office 2003. We have a suite of word based reports that get updated monthly. Each has 5 to 10 tables (occasionally graphs) that are currently linked from excel workbooks. The tables can change shape (extra rows/columns) both at the start of each month and as the report is edited for that...

The scenario I am in is that I am using a pivot table to summarise an excel table. One of the columns in the table contains hyperlinks. Unfortunately these use "friendly names" whereas I need to bring across the actual link i.e...

64Bit Windows Home Premium on a Dell laptop. Daughter told she was having problems with her laptop. I found multiple issues - as far as I can tell due to a hard disk damage (see 5 below).: 1 It had had no Windows Updates since December. Windows Update reports: "Windows could not search for new...