Solved

Attachments for spreadsheet rows

Posted on 2014-03-17
5
443 Views
Last Modified: 2014-03-20
We are creating an expense report in excel to be viewable and editable in the browser for SharePoint online Office 365. Each expense item is in a row. We would also like to be able to add an attachment to that row or item that is the scanned receipt. Can that be done in excel or would we have to use infopath?
0
Comment
Question by:BobHavertyComh
  • 2
  • 2
5 Comments
 
LVL 33

Expert Comment

by:Rob Henson
ID: 39934257
Assuming the scanned receipt is saved in the SharePoint as well, you can add a hyperlink to the file address.

Thanks
Rob H
0
 
LVL 9

Author Comment

by:BobHavertyComh
ID: 39934365
That's not really what we are looking for. For example, in Infopath, we can have a repeating table to hold each individual expense item and in the last column of each item, we have an attachment control where they can upload their scanned receipt that relates to that item. Can we do anything like that in excel? And if not, would the user have to first upload the scan to a SharePoint Picture Library and then manually enter a link to this on the spreadsheet in the expense report library? That kind of sounds like asking for trouble. I guess what I need and am looking for is some sort of attachment control that can be inserted into excel cells, but it doesn't look like it will let me do that.
0
 
LVL 33

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 39934441
As far as I know, you don't have the option to physically attach an item to an excel sheet which is why I suggested using a hyperlink.

You could maybe embed the item into the excel sheet and have it show as an icon but I suspect that would eventually make the file extremely large.

Thanks
Rob H
0
 
LVL 9

Author Closing Comment

by:BobHavertyComh
ID: 39934747
OK thanks. Just wanted to make sure I wasn't missing a capability.
0
 
LVL 6

Expert Comment

by:Sushanta Sahu
ID: 39941908
An excel itself is a file and can not hold another file within SharePoint. However to simplify this, you can import the spreadhseet to SharePoint as a list and then attach the scanned copies to their respective rows.

In this way you have to take the initial pain of adding the attachments. But in long run you will be relaxed as the list itself will be holding the data which you were planning to do on excel. For better results open the list in Datasheet view so that you get an Excel like view.

Let me know how it goes.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Adoption of Microsoft’s Enterprise Mobility and Security solution and Office 365 will re-order the File Sync and Share market Microsoft has stated that its Enterprise Mobility + Security (EMS) is the fastest growing product in the history of the …
In-place Upgrading Dirsync to Azure AD Connect
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question