bugs

  1. M

    Formula.Firewall Issue

    I have an Excel file that uses Power Query to get data from two Access tables. The query is executed via the following VBA code in the Workbook_Open codeActiveWorkbook.Connections("Query - SourceFileName").Refresh ActiveWorkbook.Connections("Query - GoodsOut").Refresh The SourceFileName query...
  2. C

    Cells not returning a value - when i know the formula is correct!!!

    I have this formula that is working in several other programmes that I have made, that are identical in nature. However, this one programme fails to return the value of my concatenation. The cell returns no errors. I have set the formulas to update automatically. I do believe this is an easy...
  3. K

    is it just me or is excel for mac chock full of bugs?

    there are some software that i use everyday, are highly complex, and to mind work almost perfectly. these are: chrome browser, pycharm, mac os. i have had very few problems with these apps. pycharm, for example, i would say, crashes about once every two months and it is simply an enormously...
  4. V

    Create 3 Drop-Down Lists which Sum to Specific Value?

    Hi all, I have an excel question which I've been scratching my head about... I've had a few attempts at solving this from butchering various bits of VBA I've found, but although it works (still with a few bugs to be ironed out), I'm confident there's a better way of doing this. So, here goes...
  5. 4

    Can some expert help in MATCH() array form?

    This seems to be an Excel 2013 bug ... <tbody> A B 1 something {=MATCH(FALSE, ISBLANK(A1:A1), 0)} 2 </tbody> (Use Ctrl-Shift ENTER to enter the B1 formula after typing without the curly braces) B1 should generate 1 whereas it returns #N/A. Change the range to A1:A2 and it works...
  6. T

    Excel 2016 Bug?

    Folks, Without really explaining what I do for a living (not sure its relevent), I wanted to explain both a bug I have been experiencing as well as the typical overall workspace I'm using: First of all, I have Excel 2016 now and I use 'Excel.exe /x' in Windows 10's 'Run' prompt to have open...
  7. ClimoC

    Anyone else having inexplicable bugs with Excel 2013?

    I've been programming for Excel since about 2002, and have never run into problems quite like these. Some users in our office are moving over to 2013, and from minute one, problems are starting to show. The core of the WB is that it's an ODBC connection to a database (Query Table), and then...
  8. D

    Is this a bug?

    Sorry for the lame title, but I'm confused. I have a workbook with VBA. It ran fine on my machine but when I emailed it out, people got errors. I then downloaded the copy I sent out and also got the errors (no differences between the working copy and the email one, other than one was emailed)...
  9. F

    Excel spontaneously changing colors of individual cells

    All, I have an issue with Excel 2010 spontaneously changing coloring of some cells. I have a simple VBA macro which creates and populates sheets in a new workbook, copying all formatting information from the original workbook. Occasionally the formatting gets changed while the macro is running...
  10. E

    Bold and red specific type of text in selected cell

    I am writing a VBA to bold and red the text in a cell with the following condition - any words insided "<" and ">" or "{" and "}" (e.g. "xyz <abc> xyz <123>" becomes "xyz <abc> xyz <123>" or "xyz {abc} xyz <123>" becomes "xyz {abc} xyz <123>" the following code is what i try, it work normally...
  11. B

    Possible Paste Excel Bug?

    Hi All, I have scanned this forum a few times over the past few weeks and have found lots of handy tips to help me with a spreadsheet I've been working on for a Football Predictions League that we do at work. I am hoping that someone may be able to give me a bit of help with an issue I have...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top