Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space

Error while accessing Office Exel Files via IIS.

ERROR :

Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space.
• To make more memory available, close workbooks or programs you no longer need.
• To free disk space, delete files you no longer need from the disk you are saving to.

RESOLUTION :

 Go to run type dcomcnfg.msc
Click >Component services >Computes >My Computer>Dcom config> and select micro soft Excel Application>
 Right Click on Microsoft Excel Application>Properties>Give Asp.net Permissions
 Select Identity table >Select interactive user >select ok




That's IT.

Cheers!!!!!

free spam filter exchange spam filter exchange spam filter exchange spam filter exchange spam filterexchange spam filter exchange spam filter

How to Create Drop Down Menu in Excel

Solution

1.     Open Microsoft Excel.

2.     Enter numbers in A1:A10 as the list source. These numbers will appear in the drop-down list. Select the cell (here is E5) that will contain the drop-down list. Choose Date-> Date tools-> Date Validation to access the Data Validation dialog box.

Enter source and access the dialog box.

Data Validation dialog box

3.     In the Settings tab, select the List option in Allow drop-downlist. Make sure that the In-Cell Dropdown check box is checked.

Select the list option.

4.     Then, click here . The following dialog box will appear.

date validation box

5.     Select the items that will appear in the dropdown list from the worksheet using your mouse , click and return to theData Validation dialog box, click OK.

6.     Then, a drop-down list is created .

A drop-down list is created.

Tips

• If your list is short, you can enter the items directly into the Source control in the Settings tab of the Data Validation dialog box. And separate each item with list separators specified in your regional settings.
• If your list is in a range on a different worksheet, you can provide a name for the range and then use the name as your list source (preceded by an equal sign). For example, if the list is on a different sheet in a range named List, enter the following: "=List".

exchange spam filter exchange spam filter exchange spam filter exchange spam filter exchange spam filter exchange spam filter