phantom

I have been working on this spreadsheet for a few months and it is just about ready for prime time. Unfortunately it has decided in the last couple days that it has links and it asks every time I open it about refreshing them. The links are phantom and don't exist anywhere except in the warped...

Looking for some help with a formula that figures use tax based on type of job and state. Excel version 2016, windows 10 D4 can be install or product I currently have a working formula =IF(ISERROR(SEARCH("inst",$D4)),0,((L4+Q4)*0.06)) If D4 contains inst it will multiply cost of job by .06 to...

Out of the blue, Excel 2016 has started doing this. When I typed 1.5 and hit Enter, the entire row got the top and bottom border. When I entered a number in E2 and then deleted it, the cell got a border all around. These are phantom border. If you print-preview, they do not appear. They also...

I have a workbook with a lot of subroutines that I've authored. I am having an issue with one of my subs taking way too long. For this investigation I used the Task Manager to track down the problem. When I start the sub(routine), Excel is using 100MB of memory, when it's finished Excel...

tengo una hoja de un inventario que acabe de digitar a excel, el problema es que lo digité en diferentes libros de excel, ya lo pasé todo a un libro pero las cantidades están en columnas diferentes, si sumo ambas columnas pareciera que todo va bien. Excepto que los códigos que no tienen...