To search for and locate files you want to delete, see Narrow your search results on Mac. If an item is locked, click Continue to confirm you want to move the locked item to the Trash.
#WHY CAN'T I DELETE IN EXCEL FOR MAC PC#
If you do run into a broken link, it can be fixed on the PC by choosing File > Info > Edit Links to Files… provided you can locate the Excel file in the first place. On your Mac, drag the item to the Trash in the Dock or select the item, then press Command-Delete. And if you rename or delete it, or if someone in IT changes the server path, then the link will break, leaving you with our dreaded error message when you try to change a number. But if you choose to link a chart, then it is your responsibility to keep track of that Excel file. There are many advantages to linking, including smaller file size and maintaining an external data source that can be updated by others across an organization. Consequently, many users get lulled into thinking the data sheet is actually embedded. If you right-click a chart to edit the data, PowerPoint will launch that linked Excel file with little indication that it is opening an external file. The next two options will link the chart and its data, leaving it in the Excel file. And yes, some HR people have been fired because they unwittingly sent out salary data to an entire company. It also means that if you have sensitive information on an unrelated tab, anyone with that PowerPoint slide will have access to that data. And that means that your PPTX file may suddenly balloon in size if the Excel file is a large one.
But be careful, because not only will the chart be embedded, but the entire Excel worksheet will as well. This can be quite helpful if slides are being shared between users, computers, and offices. Embedding means that the data sheet will always be accessible for content edits by anyone who has the PowerPoint slide. Generally, we want a chart to take on the look and feel of the destination PowerPoint file, but the real consideration here is the embedding. The first two options and will embed the chart either with the theme of the source Excel file or with the theme of the destination PowerPoint file. Let’s examine these five choices including the pros and cons of each.Įmbedding Excel Charts in PowerPoint Files While this may be your preferred choice, it can also lead to the above error message and tears and canceled dinner plans. Ignore this prompt at your own peril, because if you take no action, then PowerPoint will perform the default action which is to link the chart using the theme (look and feel) of the PowerPoint file. More after the jump! Continue reading below↓įree and Premium members see fewer ads! Sign up and log-in today.
0 kommentar(er)
