MS Excel
I have no idea on how to accomplish a project I am planning to create. Is it possible to use a date selecting box or use a date range to limit a combo? How can I accomplish this? I want to create a form so that I can see members who is no longer active in an event on a certain date range and select from it. Individual ID, Name of the member and position must be in one main table.
Further each table should contain multiple records of the same person during various ranges of dates. This will serve as reference for the start and end date of joining activities. This is to select who remains every time I add someone to any event.
PLEASE HELP!! Thanks in advance!
- 822 views
- 1 answers
- 0 votes
Hello,
I am trying to save a file using Microsoft Excel but it says “Microsoft Excel cannot open or save any more documents because is not enough available memory or disk space”. I tried many steps to resolve this error but could not fix this issue. Help me to resolve this issue.
Thanks.
- 1081 views
- 2 answers
- 0 votes
Hello,
I had lost my data and tried to recover data from different tools and fortunately, I retrieved the lost data back with a new error message. When I tried to open, any excel file I got the following error message. I have tried many solution to resolve this problem but still unsuccessful. I need your help to fix this issue as soon as possible. Thanks.
- 729 views
- 1 answers
- 0 votes
Hi experts,
I have installed Dynamics AX 2012 and installed Excel 2010. Now I am trying to remove the following error message. I get this error when I click on the Connect Button in Dynamics AX tab. Help me to resolve this error immediately.
Thanks.
This operation is not supported for a relative URI.
- 810 views
- 1 answers
- 0 votes
Hi,
I am getting the following error while connecting the LogisticsAddressDistrict table in MS-Excel through Add-on.
I want to remove this error so I need your help to resolve this problem.
Thanks.
Dynamics AX Error
Cannot load [LogisticsAddressDistrict].
Tables must have a valid replacement key or primary index other than RecID for use in the Office Add-ins
- 657 views
- 1 answers
- 0 votes
Hi guys,
I want to use the add-in option for Excel 2010 but the config menu does not appear in shape example.xls
Has anybody got any ideas as to how I run the configuration; I can't find the RTI menu on my file. When I open Excel I get the following splash screen then nothing seems to work.
RTI Spreadsheet Add-in for Microsoft Excel 1.L2
- 932 views
- 1 answers
- 0 votes
Hey,
I recently saw the free app for The OnLive Desktop on the iPad and saw it included excel 2010.
I was wondering if it comes with any kind of storage and if it includes anything else from the Microsoft office package?
- 904 views
- 1 answers
- 0 votes
Hi, I use Microsoft excel 2007 and was searching for a utility tracker spreadsheet template to use it for tracking utility bills and manage costs as well, I already found lots of templates on Microsoft Office website including hundreds of tracker spreadsheets, I already picked Activity-based cost tracker template but I’m afraid to mess on it, how can I make the best use of it to be able modify some parts and titles of the sheet without losing cell references and functions used in the sheet?
- 938 views
- 1 answers
- 0 votes
Need a serious excel formula knowledge people here.
I had created an awesome spreadsheet that is that bloody good that was spread to my officemates. I have a few formulas-cells that display specific info-text when selected, and display specific error-message when data is entered, because I limited input to ZERO characters, so overwriting is not possible. Entering values is impossible, because of the validation, however it is possible to delete the formula.
How can I prevent the formulas from getting deleted?
I DO NOT want to use common password-protection, because I want to specify the error message myself by using validation.
Anybody knows how to do this?
- 818 views
- 2 answers
- 0 votes
I have realized we can do dso analysis in excel (Days Sales Outstanding) by taking average accounts receivable during the month / net credit sales during the month and multiplying by the number of days (30 days). I can see there could be an accounts receivable if the business has its own credit arrangements with customers, however I don't understand how the DSO formula works?
- 655 views
- 1 answers
- 0 votes