Hi,
New here and searched all over the internet and could not find an answer.
I have a CSV file with 499,846 rows in it.
Each row has a field or spaces separated by commas. The commas are used as delimiters so when I open this CSV file in Excel, those commas will be used as rows.
Example...
I am not sure if this can be done but I want to create cells on sheet named Auto that instructs the user what to input and then disappears when the value is entered. For example, in cells L53:L153 I want the text to show 7389 and it cells M53:M153 I want the text to show 03499 and it cells...
Hi all,
I've created an add-in that is deployed on a network (I keep a local copy for making amendments before uploading to the network). The add-in works fine for most users but for some it disappears (remains in the add-in menu but is unticked and the custom menu disappears) once Excel is...
Hi guys,
I recently was upgraded to a windows 10 system with Excel 2016.
I'm having a recurring issue when I'm working with large files (last happened on a 15mb file) where whenever I try to save the file, excel disappears. It just closes.
I’m not getting “ File not Responding” message nor...
Hai
how to maintain source file name when we import from folder csv files. I have a problem that the file name disappears after expanding the binary.
Thank you in advance
Hello wonderful excel community,
I'm creating a template for users of both mac and excel and have received feedback that the cursor occasionally disappears on Mac Excel. I've done some testing and have discovered that it appears to happen after I use an input box.
This only happens when you...
Hi Guys,
I need to ask a question, I no longer have my desktop PC and now been supplied Microsoft surface pro, but the problem I had was I had an older version of excel, but they have now supplied me with Office 365. My excel has VBA and Command button, now when I run the VBA, the information...
Hi,
I am not sure if this is simple or not but I have a table that looks something like this
cells A7:F7 contain formulas. the table need to be updated once in a while by inserting a new column, but when I do this, the formula disappears from the corresponding cell in row 7.
[/IMG]
When entering a formula in a post containing the " lesser than" operator all text starting from and including this operator disappears when I save the post.
Any work around available?
Thanks
When I type in a cell...and then click or enter through to another cell...a border appears (seems to be Top & Thick Bottom Border) on the entire row i just clicked out of. Then a short while later it disappears. I don't understand what is happening. There is no border highlighted...I click no...
Hi, I am trying to plot a Mandelbrot using "gdi32" library function SetPixel after setting 1DC = GetWindowDC(0)
Seems to work initially but the Excel window seems to reset/refresh halfway through the plot and either stops plotting or the completed portion of the plot disappears completely.
I...
Morning all,
Im putting together a process which includes lots of screen shots but when I try to capture a filter in drop-down it disappears before I can capture the image.
Is there a way of doing this?
Thanks in advance.
Stuart
For some reason, cannot see the status bar unless I close the ribbon. This is pain when doing link worksheets. I have looked at the options dialogue box and tried help, but nothing seems to address this.
Any help out there?:confused:
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.