MS Excel
I have created a worksheet which is used to upload information into a database that has various validations and database insert macros running in the background.
But when I attempt to Cut and Paste rows into my worksheet, I get an alert message box with the title "Microsoft Visual Basic" and then the message 'File not found'.
When I hit the “OK” button in the window another alert message box is opened saying "Microsoft Excel cannot paste the data".
However when I close this message box the data is pasted into the worksheet.
Could it be that there is something wrong with my VBA code?
- 12613 views
- 9 answers
- 4 votes
I am currently receiving an error in Excel. When I get the value of two cells it returns an error like this #value
Is it because that it could not fit into the cell or is it something with the math of my MS Excel?
Please help me with a step by step guide because I'm not good with Excel that much.
- 1224 views
- 4 answers
- 0 votes
I think there is a simple solution to this issue but I don't know VBA.
I have a 15-minute interval information for 395 consecutive days. The information is in a 6290 x 6 (r x c) matrix, so each 16 rows represents the information for day. I'd like to somehow convert this immense block of information in to a 395 row matrix where each row is a complete single day.
Any suggestions?
- 1444 views
- 1 answers
- 0 votes
Hello,
I have a query about Excel. How can I receive a column (bar chart) which will include variables as a sum?
For example: I have variables: A and B. A =20% and B=40%. I require a column which will depict the sum of these variables (60%). But I require in the column to be obvious that from the 60% the 20% comes from variable A and the 40% from variable B. So, the Column ought to be divided in two parts (in proportion).
Lots of thanks.
- 1020 views
- 2 answers
- 1 votes
Hi Experts,
I am having a minor issue with my Microsoft Excel together with its macro. I got no problems with the result that the macro is giving me, but what I am bothered it, whenever I enable the macro and the link as well, it does not give me a pop up. But, when my officemate’s computer is used in enabling the macro and the link, there is a pop up after that.
Well, if you are to ask me, why the pop up is important, it is because it will show me if the link that it opens is correct and not just an Excel file with a duplicate file name in the shared drive.
So, I want to have the pop up show after enabling the macro and the link. Please help me. Further information, I am using a Vista machine and Excel 2007.
- 1079 views
- 1 answers
- 0 votes
I met an error as I was opening the Microsoft Excel. It stated
Error Starting Microsoft Excel.
Turbo Law could not start Microsoft Excel to display your document. The error was : Retrieving the COM class factory for component with CLSID (00024500-0000-0000-C000-000000000046) failed due to the following error: 80040154.
I think my Excel has a problem. I did try removing the Excel then installed it again. I restarted the computer and again opened it but same error still existed.
I need some help guys.
- 1560 views
- 2 answers
- 0 votes
Error on inserting Rows and Columns in Microsoft Excel 2007
Whenever I am inserting either row or columns I receive the following error message, but in my previous work only.
But if I created a new one, the error doesn’t appear. What have I done for this message to appear?
Help me please!
Thanks!
- 3413 views
- 2 answers
- 0 votes
Microsoft Excel 2007 AVE (Average) function not working.
I am new in Windows 2007. I previously worked on Lotus 123 and Quattro.
I know that Microsoft Excel and Lotus 123 and Quattro are the same in function.
Why can I not get the exact result when I am getting the average function in Excel 2007?
I got the result #NAME?
What does it mean?
This is the formula: D11 = AVE(D1:D10)
- 2487 views
- 4 answers
- 0 votes
I had a problem regarding my Microsoft Excel program.
I had from Odesk that should need to use Excel for the data that been gathered.
When I'm trying to open the program an error shows up stating data may have been lost.
Now I feel frustrated since I can't have the job for now since my Excel isn't working.
Please help me.
- 1046 views
- 3 answers
- 0 votes
Hi folks,
I was at home to finish my work from the office.
When I was about to open the file that I brought from office, I met an error that said, File error: data may have been lost.
I pasted the error message below.
File error: data may have been lost.
When I saw the message, I was afraid that the work I have done for the whole day was gone.
When I checked my file with my laptop, I can open it.
Why is it, if I will use my desktop computer it will not open?
I removed and added Microsoft Excel, but same problem exists.
- 2561 views
- 6 answers
- 0 votes