Hi All!

I want a cell to only have 1-999999 input. Now the error message is set, but what I want is that when an invalid data is entered I could choose to leave the data.

How do I do that?

Data Validation

Error Alert

Error message: The range of invoice numbers is from 1 – 999999.

This is only a check for values in the proper range and does not validate against a list of orders.

Hello,

How to create excel planning boards? Or can I download a free sample for excel planning boards as a basis or reference? If you have some idea regarding this matter I need your help guys. Much appreciated if you do. Thanks

I have dj bpm spreadsheet which contains a huge data about dj bpm but this is old.

How can I gather more dj bpm information through internet?

I need a excel 2010 macro wmi to help me extract username from wmi.

I have windows 7 and office 2010 on my laptop.

Where can I get an advanced daily activities spread sheet free to record my baby's everyday development. I would like to keep a bi monthly record.

Hi Experts,

I installed Microsoft Office 2013 replacing Microsoft Office 2007. When I tried to open Excel interrupt application through Visual Studio 2008 I received some warnings. Those warning are not familiar to me. See the screenshot below. I tried several possible solutions to solve this problem.

But I failed. Finally I uninstalled Office 2013. But still the problem is here. If you have any idea regarding the error message please help me.

Thanks in advance. 

How to organize DVDs excel so that all the pages are linked to a single main page. The main page will have different categories such as genre, actor/actresses, year etc. What I want is when I click on a genre say comedy it should take me to pages which have comedy genre mentioned.

Hi Experts,

I wrote the following code for downloading an excel file:

Hi Experts,

I cannot open the file with the extension .xlsx with Microsoft Office 2013. But it is easy to open the same file with Microsoft Office 2010. However, it says

Excel cannot complete this task with available resources.

Choose less data or close other applications”.

How to fix this issue?

Please help.

Hi Experts,

My PC is running with Windows 7 x64. I installed Microsoft Office 2010 32 bit on it. I replaced Product Design Suite Premium 2012 with Product Design Suite Premium 2013. I also installed 4 vault hot fixes.

Whenever I wanted to work with MS Word, Excel or Outlook it indicated a blank Vault Ribbon Group. Even it did not display the headline of Ribbon Group. I found it in the Vault Ribbon. But some of it worked and some of it did not work.

I tried several times to solve this problem by myself but no result.

Please suggest me to solve this problem.

Thanks in advance.