MS Excel

MS Excel

Hi there,

I am working in my office about Excel. When I finished the work, I closed the window manually.

Next day when I tried to open the Excel file, it did not open, instead the only showed file is 0 KB.

I used ".xlsx recovery software", but no result was found.

Although when I used recovery software the file size came back, but it did not open.

In these circumstances, what can I do ?

Please solve my problem.

  • 1376 views
  • 2 answers
  • 0 votes

In my current job, I am assigned on the record keeping of all the operations of the fam. I found it very helpful to input all the details in a MS Excel spreadsheet. To note any information I cannot include in a cell, I use the comment function. Unfortunately, my CPU crashed but the good thing is I have backed up all my files.

The company has issued me another CPU which I can use for my record keeping tasks. To take note, this CPU has been used from other department. I would like to know how can I change the name that automatically shows when I am using the comment function to note that it was my work and not by anybody else?

  • 1117 views
  • 2 answers
  • 0 votes

We use an Excel file for our business to track our daily sales and there is a particular cell on the file where a date needs to be entered. When I right click on the cell and click on Format, and then I go to the Number tab and select Date under category, what's selected there is *3/14/2001. However, when I enter a date such as 8/15/2011, I get an error message "DATA FORMAT INCORRECT! Please ensure your date is formatted MM/DD/YYYY".

  • 1098 views
  • 2 answers
  • 0 votes

Documents Inspector is a very important factor for an Excel file that I found on Microsoft Excel 2007.

However, I do not know how it is used and what are its activities.

I am very much interested to know about Documents Inspector and how to use it.

  • 1339 views
  • 2 answers
  • 0 votes

Recently I set up a Pivot Table in Excel which shows inventory purchased and inventory sold for my business. I would like to add a simple calculation in the Pivot Table showing the difference between the amount purchased and amount sold, giving me my on hand inventory.

Can a calculation be added to a Pivot Table once it has been set up?

  • 1988 views
  • 2 answers
  • 0 votes

I have an Excel spreadsheet which gets some of its information from an Access database. I have written several macros in this spreadsheet using Visual Basic code. I find that gives me more flexibility than just recording my keystrokes. I would somehow like to create a macro in this spreadsheet which would open the Access database and, if possible, run a macro contained in the database.  

Since all of my Visual Basic knowledge is self taught, I am not familiar with all of the code. What code should I use to switch from one program to another? 

  • 1024 views
  • 1 answers
  • 0 votes

I just need to convert data containing survey forms from PDF format to MS Excel format so that I can apply formulas on it. Can anyone please help me how to do it? Any ideas how to do it not manually?

Thank you.

  • 2277 views
  • 3 answers
  • 0 votes

I have a big Excel file, so I would like to move my data from column to row. But if I do it manually I shall be needing a huge amount of time.

I need to know if there is any auto system which can help me move it quickly without losing any data.

  • 945 views
  • 2 answers
  • 0 votes

Greetings.

I need a help on how to add security password to one of my Excel files? I am using Microsoft Office Excel 2007 and I have this important and confidential file and I want to add extra security by entering a password before it can be opened.

I already explored the menus in Excel but I can't find the option for putting a password to my file.

Your help will be highly appreciated.

Thank you.

  • 2082 views
  • 4 answers
  • 0 votes

Hello society,

I have Windows 7 OS and version of Office 2003. The problem happened when I tried to install Office 2010.

Installation was functioning normally until the end when I got this notice:

Can anyone help me ?

I tried to reinstall it but every time I get same notice.

Error:

Microsoft Office Professional Plus 2010 encountered an error during setup.

  • 1541 views
  • 1 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...

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...

How To Differentiate Demand Generation From Lead Generation

Lead generation and demand generation are two of the business strategies that help businesses grow. It creates a pipeline of interested customers looking to find out more. Lead generation on the contrary, is able...

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...