MS Excel

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

Latest Articles

Benefits Of Storing And Sharing Documents In The Cloud

Have you ever wished you could access your important documents anytime, anywhere? With cloud document storage, that wish becomes a reality. In today’s fast-paced world, secure and accessible document management is more essential than...

Finding Your Tribe: The Best Online Casino Communities

The world of online casinos isn’t just about spinning reels and chasing jackpots. It's also about connecting with others who share your passion. Online casino communities offer virtual gathering spots where UK slots players...

From Lost To Found: Restore Your Data On Windows 11

Are you worried about data you lost during some operation on your Windows 11? Don’t worry; we are here to guide you on how to recover the lost data from your Windows device in...

Latest Blogs

Top 10 New Laptop Entrants That Shook The Public

The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...

10 Facts About The Dark Web

Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...

Top 10 Latest Steam Cleaner Machines

While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...

Latest Tips

Top 10 Internet Monitoring Software

Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...

Top 10 Best Partition Manager Software

A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software. 1....

Top 10 Best Online Music Production Software

Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...