Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: resizing dialog box in Macro

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
resizing dialog box in Macro
I have a Workbook uploaded as an example. Please view! I need to know how to make the dialog box that contains the final search information bigger horizontally. The box automatically adds information to several lines and seems to be confusing in its presentation. I would like to have all the...

Excel Help Forum - Excel General: Number of days within a period

Feed2Mail notification - new post on Excel Help Forum - Excel General
Number of days within a period
Hi there! Was wondering if someone could help me. I need a formula to return the number of days in a period (EG 01/06/2011 - 30/06/2011) that falls within another period (EG 15/06/2011 - 15/07/2011) So if period 1 is your leave days, then how many of your leave days fall within period 2?...

Excel IT Pro Discussions Forum: Major problem when working in Excel 2010 and upload an earlier version/losing...

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Major problem when working in Excel 2010 and upload an earlier version/losing data to Sharepoint document set

We are using SharePoint 2010 server, IE 8 and Office 2010.

We have several users that works on a Excel document all day, but when closing excel and the Upload center seems to work right (successful logged) it uploads an "earlier" version of the Excel document to SharePoint document set. See below that shows the size (størrelse) is exactly the same.

There is no conflict in the upload center.

We have issued a couple of things that shows that Excel is not robust enough.

  1. When saving twice (button and/or ctrl+S) with 1-2 seconds between we get the yellow line "Keep my version" or "Keep server version". When keeping server version it overwrites my existing Exceldata.
    The odd thing is that saving continuous and the date on file in SharePoint is updated, but somehow it has an older version when using "Keep server version"
  2. The users have the Excel document in edit modus, working with something else, and when going back to the Excel document they click on the link in SharePoint document set to open it again. Sometimes my excel documents will be overwritten with old data. The users get a message sometimes - but not always

What we are wondering most about is:

  • Is Excel not robust enough with SharePoint (and upload center) and because of some wrong user interactions the data is lost? Even if using edit in excel from dropdown list og Edit workbook inside Excel
  • Or is there another issue to this that uploads an earlier version?

Same version

 Thomas

Excel Help Forum - Excel Programming / VBA / Macros: Userform - Date entry

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Userform - Date entry
Hello All, I am currently trying to write a simple visual basic application (my first time using the language) which calls a userform with several textboxes. The information from these textboxes will eventually be used to generate a report. I am having some problems entering a date into one of...

Excel Help Forum - Excel General: Use the table to calculate differetn quantities

Feed2Mail notification - new post on Excel Help Forum - Excel General
Use the table to calculate differetn quantities
hi, i started a spreadsheet yesterday and have gotten alot of help from the people on this forum. Thanks. in expanding more precise spreadsheet and for learning, i would like to add a quantity in the spreadsheet so that it does differetn quantities. For example: In B3, that is a set price for...

Excel Help Forum - Excel Programming / VBA / Macros: If cell = value then insert comment

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
If cell = value then insert comment
Hi All, I am currently trying to write a macro which will read the individual cell values in Column I (i), should that value be greater than 1.1, then insert a comment "greater than 1.1" into the corresponding cell in column S. I.e. should column I2 (i2) has the value 1.3, then cell S2 will...

Excel Help Forum - Excel General: Moving the data to a new tab but not affecting the formula

Feed2Mail notification - new post on Excel Help Forum - Excel General
Moving the data to a new tab but not affecting the formula
Hi, I have data in a worksheet that has some formulas built into it that reference specific arays of data on the same spreadsheet. I want to clean up the sheet and move the aray data that is referenced in the formula to a new tab but I still want the data in sheet 1 include the aray data. How do I...