bug

I have a simple sheet with three ActiveX controls (one for each report) and a pivot table. The Pivot tables shows a list of parts associated with a charge unit. The user selects the charge unit in the pivot table then clicks the ActiveX control for the report they want. Sometimes the user...

Hi all. I'm running a very simple SELECT query off some Oracle tables in Access 2007. When I first run it, I get 8,237 records appear. The last one is a duplicate which, as far as I can tell, shouldn't be in the results. When I sort the results by the ID field, I only get 7,853 records, and the...

Hello, I am having some issues testing an Excel 2003 template in Excel 2010. My main issue is with Data Validation lists. When I export an .XLT worksheet (saved in 97/2003 format) that contains a number of Data Validation lists and then open it in Excel 2010, some of my validation lists...

Hi everyone, I made some progress since last time I asked a question (copy and paste transpose). But now I think I have a bug. Each time I create a new chartsheet, the first chart of the SECOND (and 3, 4, 5...) are not sized correctly but The first chart of the first sheet is perfect. I...

Hello, I'm having trouble with excel 2007 plotting my maximum date/time on the x axis properly. I have set the maximum value as 40155.08333 (12/8/09 02:00); however, the maximum value keeps plotting as about 40155.2 (12/8/09 04:45 ish). I am thoroughly stumped. Ancillary information: The x...

I am using the following code to copy changes to a cell value every 30 seconds. The code works, sort of, but has the following bugs; When timevalue = 5 seconds it copies every 5 seconds but copies the change into 5 cells at a time. It will only fill 64 rows and then stops copying. If I change...

Hi, I am a frequent reader of this forum and learned quite a lot from you guys so I hope you can help me in my current situation as well because I haven't found the answer anywhere. I have a big file that I have been working with for a while. Many formulas, links between tabs and so on. Not...

In Episode 1175 When Bill adjusts the formula the value reads as 7. However when he copys it down the value changes to 8. I had a closer look and when he copies the formula down ALL the data values (B2:M4) change. Why is this? What happened there?

According to Excel Help, the arguments of CreateNames method are optional: yet I found that even after I specify one, in VBA, Excel STILL guesses for the text labels. This happens only when the values are texts. So for example, I have two columns range, say "A:B". "A" contains text for the...

Hello, I have been assigned to investigate an issue we’re having with a Web Query using Excel 2003 from IE8. Basically the problem is that some of the numeric values from the page appear as numbers in Excel and some appear as text in a single column. I’ve managed to find what seems to cause the...

Hello, New to the Forum. Looks great!! I am pulling out my hair at the moment- :rofl: I have learned that the ROUND function functions differently in VBA vs. in a worksheet. I have found an MS webpage that explains and also gives some alternate functions that "should" solve the problem...

I have a file that basically lists tasks, one per row, with lots of stuff about each task. In Column B, there is a drop-down list from which you can select "Completed" among other things. The conditional format turns the entire row to a gray font if this column B item for that row is selected to...

Hey there, Has anyone experienced the ARRAY.JOIN function producing different results (when combined WITHIN the UNIQUEVALUES function) when used in the same workbook, but opened on different computers all using the same OS (Windows XP) and the same version of Excel (2007 with all updates...

I have a workbook with about 15-20 different queries. The queries all execute fine. I needed to add 8 more queries. The first 3 added fine. However, now whenever I try to add a new query, everything appears fine, but when I go back into the query to view/edit it, the query is gone. I have to...