View Complete Post
We are having an issue with an Excel spreadsheet that is linked to several Excel documents in a document library. Mutliple staff members update several "sub" spreadsheets with information that is rolled up to the "master" spreadsheet. Excel appears
to behave correctly in that if I open both the sub and master spreadsheets in my Excel window at the same time, the data in master gets updated. If I just open the master, I have stale data. I'm not sure SharePoint is to blame here, so I'll post
this in the Excel forums as well, but any information or experience anyone has had with this would be fantastic.
Thanks in advance for any help/advice!
In Sharepoint designer I am trying to set a custom display form for a list, following the instructions in the Sharepoint designer help.
I've got a functional display form, called DispForm3.aspx. I know it works since I tested itÃÂ byÃÂ replacing the form name in the normal URL where a display form is opened.
However I can not get the list to accept this new form as the display item form.
In Sharepoint Designer, in the List Properties Supporting Files tab I set the Display item form to be DispForm3.aspx and press OK. When I look again I see that the Display item for is DispForm.aspx.
This happens on any list that I try to customise the display form for, even new ones.
Sharepoint designer is allowing me to set the display item form to DispForm3.aspx but is not saving it, or is failing silently when it tries to save it.
Any assistance appreciated.
When saving a file from ie. an email attachment into a sharepoint document library the files show up in explorer view of the document library but there is about a 20 minutes delay before they show up in the default view of the document library. This
is quite frustrating as because you can not see it there the users try to save as again.
This seems to work correctly in our test sharepoint environment. Does anyone have any ideas as where to start looking.
We have a farily large SharePoint site, (>20,000 Office documents), and we are running low on disk space. I would like to write a VBA program that walks through the tree (including subsites) and deletes all the document library history files
that are over 1 year old. I can't seem to find a way to access the history files unless I open each document; opening each document would cause my program to take months to complete. Does anyone know a way to get access to the history
files using VBA without having to open the Office file whose history I want access to? The only way I've found to access this history files is to use the DocumentLibraryVersions object, but it requires that I open the file (that I know of). I have
no problem walking the file tree and I have access to SharePoint Designer 2007, Excel 2007, and Word 2007 typelibs, object models, etc.. Due to policy restrictions in my company, I cannot install development tools on my machine, so I'm stuck with VBA.
Also, I won't be allowed to create a web service; although I can access one that already exists on our server in case any come with SharePoint.
P.S., I have lots of good VBA code that I've written over the last 15 years to do all kinds of tasks with Office and SharePoint that I'm happy to share if anyone can benefit from it.&
how can programmatically to upload a file to document library based on the current location for example when i was inside the subfolders and click on the custom button in ribbon it should upload file to current location entered to document library not
hardcoding the subfolders name
Thanks in advance
I need to extract the files from the document library using object model in sharepoint 2007.
Can anyone help me.
how to validate "Picture library" to upload only image files. Currently now it is accepting .doc,.txt files etc.
Is there any way to overcome this issue?